Performance - Is there a way to perform bulk insert/update/delete in Scribe Online?

Environment: Salesforce-to-Dynamics NAV 2017

Problem: Time taken by Scribe Online to integrate a single large order can be over 10 mins.

 

Right now, I am creating/updating records one at a time, and with large orders having a few hundred line items, that takes way too long - each line-item has to be inserted with its own insert statement, running various triggers in the database after each insert.

 

What I would like to do is collect all of the line-items into a list/array, and then insert the list, with just one DML statement. Is that possible?

(3) Answers

Login