AX 2012 – RecordInsertList (basic sample)

Sample code…. Bad Practice: RandomTable randomTableBuffer; // Imagine this loop returns 10000 records. while select randomTableBuffer where randomTableBuffer.RandomField1 == “1” { randomTableBuffer.RandomField2 == “2”; randomTableBuffer.insert(); } This would insert a record in the database 10000 times. Of course this would work just perfectly fine but would give you horrible performance. To avoid performance issues you […]