The following are certain tips that elevate the performance of the saved searches.
Use the Largest Filters First
The Criteria section of the saved search will filter the results from the NetSuite database. So it is appropriate that we use the largest filters (criteria that can filter out a major chunk of data) first at the Criteria section. Thereby, we can avoid timeouts to a major extent.
Avoid Using ‘Contains’ Condition
Experts say the ‘contains’ filter uses resources intensively. This filter will go and check for strings that contain a particular keyword and most likely it will give more unwanted/undesired results. Avoid this by using ‘Starts With’ or ‘Has’ and these can meet the same need as ‘Contains’ if used efficiently.
Remove Extra Columns of Data
Don’t let NetSuite draw unnecessary results from the database that are irrelevant for the user. If the result is unwanted, take it off from your saved search to optimise the performance of a saved search.
Automated Email Alerts
Send emails on records that are created or updated, or on a set schedule. This is the most known feature of saved search provided by NetSuite.
Using Formulas in Saved Searches
Saved search capabilities can be extended using the formulas and SQL statements. Embedding links inside a saved search is a least used but powerful tool to attract the attention of our users.