I have a user who has made a saved search (see below) that has many selections.
Of course the saved search is very slow and times out most of the time. What would be the best solutions to alleviate this issue? I was thinking a checkbox to select the items you want to see.
What are other solutions?
+18Is it quicker to exclude parameters rather than include? So “exclude customers beginning with 5” rather than “include customers beginning with 1 and include customers beginning with 2 and include customers beginning with 1”?
Or find some other common denominator - all customers with JBLOGGS as Salesman or FRANCE as Country?
+23Not sure if it will make a big difference, but since you only compare numbers there should not be a need for “tolower”.
The user is just using the main search filters but adding several customer nos separated by a ;
Pretty sure he is typing them in manually…
Different numbers everytime he runs the report.
The tolower is added when you look at the query from the advanced search.
No commonality in search criteria, just a boat load of records.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
