Improve performance of Dynamics 365 OData query

(0) Share

Report

Posted on by saman0suke

2,890

Hello everyone,

I am creating a VS solution to extract data out of the General Journal Account entries entity in Dynamics 365, the entity contains several records and it takes too many hours to get all the information completed, besides I need to re-run the query each time since OData only retrieves 10,000 records, so I'm doing something like this:

var records = context.SclGeneralJournalAccountEntries.Where(h => h.CreationDateTime >= dateFilter).AsQueryAble().Take(10000).Skip(20000);

foreach (var entry in records)
{
   Console.WriteLine("{0} - {1}", entry.SubLedgerVoucher, counter);
}

Is there a way to make this process faster? I'm just starting to work with OData, but again, this takes too much time to get them all; if there's a way to improve performance, I would appreciate the help, regards!

Categories:

Development / Customization / SDK

Performance

All responses (2)

Answers (0)

Suggested answer

nmaenpaa 101,148 on at

Like (0)

Report

RE: Improve performance of Dynamics 365 OData query

You should consider using something else than OData if you are handling large data volumes. BYODB is one option: docs.microsoft.com/.../export-entities-to-your-own-database

If you use OData, it's faster to fetch 10 x 1000 records in parallel than 1 x 10 000.
Abhimanyu Naruka 160 on at

Like (0)

Report

RE: Improve performance of Dynamics 365 OData query

Hi Saman

Did you found any good numbers on performance?

Thanking you

Abhimanyu