RecordInsertList Dynamics 365 Finance & Operations
A shortcode example of how to can create records in a table very performant way using RecordInsertList. Who does not know RecordInsertList, can learn more about it here.
static void HowToUseRecordInsertList(Args _args)
{
DMOPerfTest DMOPerfTest;
RecordInsertList RecordInsertList;
Counter c;
FromTime fromTime = timeNow();
RecordInsertList = new RecordInsertList(tableNum(DMOPerfTest));
for (c=1;c<=10000;c++)
{
DMOPerfTest.clear();
DMOPerfTest.AccountNum = int2str(c);
if(DMOPerfTest.validateWrite())
{
RecordInsertList.add(DMOPerfTest);
}
}
RecordInsertList.insertDatabase();
info(strFmt("Total time consumed: %1", timeConsumed(fromTime, timeNow())));
}
