A short code example how to can create records in a table very performant way using RecordInsertList. Who does not know RecordInsertList, can learn more about here.(https://learn.microsoft.com/en-us/previous-versions/dynamics/ax-2012/system-classes/gg923748(v=ax.60)?redirectedfrom=MSDN)
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())));
}转自:https://www.schweda.net/blog_ax.php?bid=509&wdl=en


留言评论
暂无留言