Extremely Slow Find Requests
I've posted about our DB running slow in the past, but the fix I tried before seems to not have done much.
Here is a description of our setup :
FileMaker Server 9 running on a Windows 2003 Server. The server is dedicated to FMS only.
All access to the filemaker is through our LAN, so there should be no problems with internet speeds.
Most people are attempting to access the DB through FileMaker Pro 9 on Windows XP machines, however, some use Mac(Macs are generally even slower than the windows boxes).
The most crucial point of slow down is on our schedules. We have a DB of 26,000 records, each pertaining to a different job, step, and machine. We have different schedules set up, and are accessed via a script that performs a find depending on the step and machine we want.
For instance, the script would look similar to :
Enter Find Mode[Restore] (Find records where process="Diecut", scheduled="yes", completed="no", deleted="no")
Set Field[Job Form Steps::machine; $machine]($machine might be "Brausse")
This script is EXTREMELY slow, specifically on the Perform Find step. I've tried a couple different methods of searching, and nothing seems to be speeding it up significantly. Is there anything I can do to make find requests faster, or am I pretty much screwed with 26,000 records?
I will do a database design report tonight, and post a copy of the scripts that are involved in this process.
Thanks a lot,
You may have tried this already but we don't know if you have or not...
Are the fields searched in the find: process, scheduled, completed, deleted, and machine all stored, indexed fields?