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
留言评论
暂无留言