RecordInsertList Performance

The use of RecordInsertList has been well documented for increasing the system performance of inserts records.But I was curious how the use of RecordInsertList would scale and what impact it would have on performance.

To understand the impact on performance and scale-ability I created a table with one field. I then wrote a job that would insert X number of records into that table using first the standard insert method, then use the RecordInsertList method. Each pass would record the number of milliseconds to complete. I did this for 100 records then 1000, 5000, 10000, 20000, 40000, 100000, 1000000 and 10000000.

Continue reading

function dimensionvalidation:: syncstructurechangesprivate has been incorrectly called

You might encounter the message “function dimensionvalidation::syncstructurechangesprivate has been incorrectly called” when dealing with importing ledger journal lines.

The error relates to a ledger dimension or offset ledger dimension being incorrectly formatted, normally as a result of data importing, or X++ code used to build a journal.

Continue reading