Title
perform find script step EXTREMELY slow
Post
I am running a script that searches about 17,000 records. It works fine and then sometimes it will go excruciatingly slow to the point where I will cancel the find. Its a pretty straightforward script that sets variables of Table::global_billed from value list:
"yes"
"no"
"maybe". (I have them as a checkbox and more than one can be selected.)
then enters find mode, set field (field::billed;global_billed) and performs find.
It goes slow specifically on the perfor find step.
Its weird because it goes slow sometimes. It might go slow when "yes" and "no" are selected or maybe just when "no" is selected.
All fields are indexed.
Do you recommend archiving most of the old records? would that make a difference, since it does work some of the time.
thanks!
Are you sure that all fields receiving criteria are indexed? What indexing options do you find specified in Manage | Database | Fields?
This description:
Its weird because it goes slow sometimes. It might go slow when "yes" and "no" are selected or maybe just when "no" is selected.
Could indicate that FileMaker is updating the indexing on the specified field. In which case, the first find may be slow and subsequent finds may be faster.