How can I improve my find? It is taking 14 seconds to complete and currently there are only 17,000 records.
My solution tracks trouble tickets for multiple customers. When the user opens the solution they select a portfolio (customer unique identifier) which sets a global variable. This limits the records visible to the user. After selection the script takes the user to a page of modules. From here the user selects the module for trouble tickets. The nav script takes the user to a list view layout. Once on the layout a scipt trigger (on layout enter) runs a script that performs a find on the trouble ticket field for an asterisk (*). The reason for the find is to remove all of the <no access> records.
FMP12 on a Mac
I've also disabled the script trigger and tried it manually and I get the same result.