This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

What can I do to debug the performance of a saved search?
One of our client complains about a certain SS saying it gets slow at a specific period during the day. Could some script be the reason? I have no idea what to do.

On average how fast is the search?  Performance will vary depending on users and other factors.  Can you add criteria like date to reduce the number of records searched? 

The client didn't specify (I will ask them)... they said it takes too long... and when I try, it is very fast... they said it happens at a specific hour in the day.

It has 11 lines in the criteria (most of them are not direct... they are from referenced/related records), and the result has to formulas, with no aggregations.

The search is over a custom record that has 30M records.

The results is usually around 3K records.

Can you add some sort of filter so its not looking at all 30M records?

Good idea, I can do that with the date, ignoring old records. I will try it. Thanks :coffee: