Create New Record In Acumatica Or Which Insert Works Faster

Hello everybody,

today I want to share results of my investigations of two similar pieces of functionality in Acumatica.

Have you ever wondered which Insert in cache works faster this:

a) var temp = (PRPayrollDetails)PayRollsDetails.Cache.Insert();

or this:

b)          var temp = new PRPayrollDetails();

             temp = (PRPayrollDetails)PayRollsDetails.Cache.Insert(temp);

If to believe to results of Stopwatch, the second part of code works faster. For my set of data, the first one took 5.5 seconds, while the second option took 4.3 seconds. And this is difference for 300 records. If you have any ideas why it can be, you are welcome to share them.

And if I had 250 records then the difference between option a and b is ~4 seconds

Curious about how Acumatica can be tailored to fit your unique business needs? Just like optimizing code for better performance, customizing Acumatica can significantly enhance your efficiency and productivity. If you have specific requirements or ideas for customization, we’d love to hear from you! Leave a customization request today and let’s work together to make Acumatica work smarter and faster for your business. Your insights could be the key to unlocking even greater potential!