Any idea how concurrency doesn't fix performance?
# performance
m
Any idea how concurrency doesn't fix performance?
m
Concurrency effects how external systems interact with your netsuite environment. Performance is usually considered the UI experience for your users. To improve performance you need to review scripts and integrations that are effecting your records in realtime. Try to schedule your scripts and integrations asychronously instead of while records are loaded and saved
Usually, when it comes to performance there is a large number of user event scripts, client scripts or event based workflows constantly running on load/save of records which slows things down tremendously
m
So the number of scheduled and map/reduce scripts that can run at the same time won't increase with a tier upgrade?
m
No what you are refering to is governance limits not concurrency
Tier upgrades have no effect on performance.
I have been through many and there is never an improvement after the upgrade
m
I didn't know that there was a limit for that. It doesn't make sense to me.
Our client has a custom record... they get like 100K per day from their own system. We have to generate journals for these records, and then send some information back to their system.
m
for performance help I usually try the following tips. 1. Use the Record Pages Monitor to find record types with large response times (over 2 sec). And high usage 2. Review scripted records for all these record types to find scripts effecting these record tyeps 3. Review each script in the script logs for consistent errors/repeated errors 4. Review each script file and see if it can be optimized or scheduled
Also one of the biggest culprits of performance is saved search. Scripts running saved searches, workflows and workflow actions based on saved search, non-stored/sourced fields coming from saved search
All of these add up if the system needs to run tons of saved searches to load or save the record it really slows things down
m
Why NS wouldn't allow the customers to throw some computing power at it?
m
I think for that you would need to look at a dedicated server for the netsuite environment
I think netsuite offers this at certain tiers
m
Hmm, didn't know that. Thanks, I will pass this to our team. Thanks again for your time and tips there. ♥️
m
no problem
j
Not to confuse things, b/c @MGBC is essentially correct, but if you're specifically concerned with map/reduce scripts completing faster, adding SuiteCloud Plus licenses and/or upgrading Tiers will impact the number of SuiteCloud processors which is supposedly what is processing those map/reduce scripts in the back end. I'm not 100% clear on how/whether this affects your scheduled scripts though. And there's a lot of other factors that can ultimately affect performance even more than processing power, especially if things are not designed particularly efficiently. Here's a table (this is a bit old, but I think it's still current) if that's helpful:
image.png
So as you can see if you just upgrade tiers, you really are getting almost the exact same thing. SuiteCloud Plus licenses are what's really affecting things, but they start forcing you onto higher tiers if you need a lot, so then you'll pay for the SuiteCloud plus licenses and the ridiculous upcharges for higher tiers.
m
We had a meeting with someone from Oracle, and they recommended the SuiteCloud Plus license too. It should double the threads. But after that, even a tier upgrade won't increase it. Although they said they can increase if they agree with the customer on that, but it is not listed in the offering. We also found some UE scripts that should run in some events only, but they run all the time now. I think fixing that will be beneficial. Will also take a deeper look at all the scripts.
s
The real solution to your problem, if your goal is a JE in NetSuite is to process the 100K records outside NetSuite and just send the info for the single JE into NetSuite.
m
We recommended that in the beginning, but they wanted NS to do this work.