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

I have a Saved Search that runs that returns 4,000,000 results.
When I add a filter that reduces the number of (anticipated) results to ~1,000,000 results, the search times out.
Anyone run into anything similar before?

What is the data type of the column you’re filtering on?

All Custom Records-

The search itself is on the Parent Custom Record and we're returning columns from the Parent Custom Record as well as Child Custom Record Columns

When I run that search, without the filter below, it works fine-

But If I add this filter.... it times out
Child Custom Record : "Custom Type" is none of "Type A", "Type B", "Type C"

To equate it to something a bit more readable....

Let's say its a Transaction Search on ALL Transactions
And it runs just fine (with 4,000,000 lines)

But when I add a Customer : Taxable = False filter, it times out

When that (should) reduce the number of results drastically

Hmm, behind the scenes what is probably happening is that it’s having to do column conversion on every row to do the comparison. I’m trying to think of why it would be in this case…