Hi all,
Attached is the script I'm working on.
Our delivery routing software sends a webhook API call whenever a task in it is updated, I have a Suitelet that catches this webhook and saves it as a record with the JSON payload to be processed by this MR script every 15min to update information on the Sales Orders about who the driver is, what stop number on the delivery route it is, if it's ready to be released to WMS for wave picking.
At the moment, I'm running into a bottleneck because the webhook is sending up to 40 updates a minute and this script isn't able to process and save the Sales Orders as fast as these updates are coming in.
Are your MR scripts able to update records faster than this? My concurrency limit is only 2.
Is there anything I can do to improve the process? I'm not sure how much better my script can be, I'm thinking more if there's a way to stop it from tiggering any UE scripts to increase the speed at which my NetSuite is able to save transactions.
I'm currently working on an alternate process to search all open transactions within the last month against those in the delivery routing software and update the transactions if the data is mismatched. But I would for now prefer to improve this existing process if I can.
Happy to share additional details upon request.