Unreasonably Slow Find

[Eggshen]

Hi,

We recently migrated from FM 5.5 to 8.5. In one of our databases that contains ~42,000 records, doing a find for field content match (e.g. =="Text") has become ridiculously slow compared to the old version.

This field is a normal, basic text field. It's even indexed. Why would a find that used to be instantaneous in FM 5.5 (with the same number of records) now take 20 seconds? Is it possible that the indexing has become corrupt? Is something else at work? Will unindexing and reindexing this field rebuild the index?

Thanks for your help!

Edited April 24, 2007 by Guest

[Genx]

Try?

[Eggshen]

No dice. Re-indexing didn't help. It seems to be only happening with the field content match search (==). Is there any documentation saying that's slower than it was before?

[Ender]

Can you provide some additional details:

What is the field type?

Is this a hosted solution? If so, what is the specific version and rev of the host?

[Eggshen]

It's a simple text field. It's a hosted solution on Filemaker Server Advanced 8.5. I'm trying to run the search on Filemaker Pro 8.5.

[Vaughan]

You're profile indicates you're using Jaguar -- this is pretty old, so it's probably on an old machine with without much RAM. The specs recommend 1 GB RAM.

BTW FM Server Advanced isn't available in version 8.5, it must be 8.0. Check the patch number (FMS 8.0v3 or 8.0v4) and make sure you are using the lastest -- I think it's 8.0v4 on Mac and Win.