Search/Find/Delete Takes a long long time!

[Jns]

Hey,

I am having this problem...

Well, I have a FMP files with around 70,000 records.

Everytimes I do a search/find/delete a record or multiple record it takes a long time to complete (average 20min). Is there anyway to solve this problem? I am sure my computer is not really a big factor since I have the latest computer components (P4,DDR Ram etc...)

Any help will be appreciated!

[jasonwood]

There was a similar post recently. The suggestion was to "Save a Copy As", and use the option "Compressed".

This will rebuild the entire database and reclaim unused space.

With 70,000 records, I'd start this at a time when you won't need it for a while (overnight).

[slstrother]

Some other things to consider.

If you have calculation fields as part of your Find and they are unstored, FM has to calculate for each record to determine if they meet the criteria. Look into storing your calculation fields.

If you have calculation fields but don't include them in your find, switch to a layout that does not display the calculation fields. This also applies to summary fields.

If sorting is one of the steps involved, turn on indexing for the sort fields.

If you perform this task via a script, add the Freeze Window script step as the first step in the script.

Increase the cache size under Edit>Preferences>Application and select the Memory tab.

Are you running the db locally? If you are running it from a folder on the network, consider running it locally. The speed of FM is dependent on disk I/O, which is much faster locally than across the network.

Hope this helps