How to Improve NetSuite Saved Search Performance and Prevent Timeouts

Optimizing NetSuite saved search performance is crucial for efficient data retrieval. When a search is timing out or running slowly, it often indicates that the system is attempting to process an excessively large number of records. The following strategies can significantly improve search efficiency:

1. Incorporate a Date Filter: The 'Date' filter is a highly indexed field in NetSuite. Adding this filter significantly reduces the number of records the search needs to evaluate, thereby improving performance. Other transaction fields may also be indexed, and leveraging them can further optimize search efficiency.

2. Optimize Searches with Multiple Joins: When a saved search involves numerous joins, consider restructuring the search to originate from the joined record type itself. For example, if a Transaction search includes many 'Item:...' filters, creating an Item search instead can often yield better performance.

3. Avoid the 'Contains' Condition: NetSuite best practices recommend avoiding the 'Contains' condition in saved searches due to its performance impact. Instead, utilize more specific and efficient operators:If all desired records begin with the value you are attempting to match, use 'starts with' or 'keywords'.If all desired records contain words beginning with the value you are attempting to match, use 'has keywords'.Additionally, when troubleshooting performance issues, it is advisable to rebuild the saved search incrementally, adding filters one by one to identify which specific filter or combination of filters is causing the performance degradation.