Hi Chen,
The DI API is an interface that mainly only calls stored procedures and functions. So if you feel that it is slow, the answer can almost always be found in the quality of the database, or the hardware specifications of the server the database is running on, or the network the data is transferred through. Last but not least, it can also be because of less-than-ideal setup of your business scenario in B1.
If updating an item through the DI API is slow, you can compare it with the Data Transfer Workbench, which also uses the DI API. If the DTW is equally slow, the cause is likely one of the reasons mentioned above. If the DTW is faster, the cause of the slow performance can possibly be found in the rest of the code of the addon. One example of this, that I have experienced myself, was me having an open sql connection to data that I was trying to manipulate at the same time. Just to give you an idea of things you can investigate.
Regads,
Johan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.