I am writing to see if anyone is experiencing general performance concerns in their accounts (not eCommerce related). We are seeing the following issues in multiple client accounts that appear to be related to bad index issues. These issues are sporadic in that most of the time, on average, performance is reasonable. Yet, invariably, there are performance issues that crop up that are infrequent and frustrating enough to wonder "what is going on?". Here are some of the issues.
1. Loading and or saving a Sales Order may take 30 to 90 seconds
2. A Netsuite Advanced Project has references to saved searches to draw related invoices. At times, it can take 30 to 90 seconds to load the records. There is only 5 items in the return list. The project is referenced in the invoice name transaction column, right where you expect to have an index.
3. Saving a time entry record can take 30 to 60 seconds.
I can spout more examples. In each of these, we go to NetSuite Support for help. We get the usual "Scripts need to be evaluated" response. We can isolate the custom scripts to make sure it is not our scripts. Sometimes, we get a defect (most recently, in a Sandbox account). We further have seen these types of issues in NetSuite accounts with no scripts installed: basically a virgin setup with little data in it.
The issues seem to be classic database corrupt indexes. But we are generally concerned because we are seeing it across multiple accounts and each client is exhausted trying to go to NetSuite Customer Support for help. I suspect I am not alone. So I am curious if we can gain consensus about an issue that is larger than a specific account.
Finally, I am curious if the Script Performance Monitor may detect these issues; we now call them "large standard deviations" from the mean performance issues.