Example of how to use RecordInsertList

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

    Danzel
    Danzel管理员

    • 声明:本文由Danzel于2023-11-02转载(优化),转载须经原站同意并注明出处。
    • 本文地址:http://maryd.cn/?id=278
    上一篇:系统提示“由于管理员设置的策略,该磁盘处于脱机状态”
    下一篇:电脑开机时小键盘自动启用

    留言评论

    暂无留言
    取消
    扫码支持