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!
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.
Hi Saman
Did you found any good numbers on performance?
Thanking you
Abhimanyu
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,522 Super User 2024 Season 2
Martin Dráb 228,441 Most Valuable Professional
nmaenpaa 101,148