For the past two weeks our accounting team has been stating reports seem to be running extremely slow. I initially assumed it was due to a temporary network problem, etc.
This sudden increase in run time seems to have started in the past two weeks.
After some testing I have so far validated that Balance Sheet and Income Statement reports take over 30 seconds to run in Production.
The same report runs in our Sandbox in less than 5 seconds.
The "Performance Details" popup shows the Total time is 10x less than the actual render time--but the progress indicator does not go away and present the results.
Debugging in Chrome (yes, I'm going way under the hood here) shows the reportrunner.nl script firing every 4 seconds and getting a response of status="pending", as follows:
<?xml version="1.0" encoding="UTF-8"?>
<nlresponse reportaction="getreportdata" status="pending" page="0" pagesize="60" >
<data>
</data>
</nlresponse>
After 10 passes, the status goes to "ok" and the results flow in.
For example: a Jan 2022 Balance sheet took 44 seconds to switch from "pending" to "ok" messages, but for some reason shows only 3.577 seconds in the Performance Details:
Total 3.577
Server 0.555 (15.52%)
Server Suite Script 0 (0.00%)
Server Workflow 0 (0.00%)
Network 0.257 (7.18%)
Client 2.765 (77.30%)
Page /app/reporting/reportrunner.nl?cr=-202&whence=
Email <redacted>
Time 4/4/2022 5:38 pm GMT +4
Basic, default reports are literally running 10 times slower than they were just 2 weeks ago.
After contacting support, we were advised that due to our support level of Basic, they could only direct us to the (completely useless) articles about performance tuning in SuiteAnswers.
I'm reaching out to my NetSuite sales partner firm to see if they can get any further.
Anyone else see something like this? Is there any customization mistake we could have made that would cause basic financial reports to slow down so much?