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!
