We have an existing integration between our software application and NetSuite, based upon SOAP requests. There are two scheduled synchs that occur: every 5 minutes, and on a nightly basis. One of the major issues that we are experiencing is related to the amount of time required to receive a response from NetSuite after the initial request is sent. The web services method we are using is based on a standard NetSuite user license. How many concurrent sessions are allowed with this license type? I have read in some places that it is 10, however, maybe this requires a special license type? Otherwise, we are only opening one session at a time.
The sync that happens every 5 minutes reads our production database for updates that have been to demographics data (Name, Email, etc.). If the record in our application experienced a change, it is placed into a queue/file that is sent to NetSuite every 5 minutes. Our process checks the records in the queue to ensure they are sent to NetSuite. If there is an error/issue, the record will be backlogged and included on the following update.
Our other sync that occurs every night, takes on average, about 3 hours to complete. There are approximately 150,000 – 200,000 contact records that are affected by this nightly update. All data that is pushed into NetSuite are for custom fields. We have observed that it takes 75 seconds to perform the import of a file with 100 rows.
Is it possible to accelerate the uploads and reduce the time it takes to complete the syncs? Are there additional user license types we can use to improve this performance? At this current rate, the time required is not scalable since we will potentially reach 500,000 records that need to be updated on a nightly basis. Does anyone have a list of best practices we should be following?
