Jump to content
Sign in to follow this  
Eggshen

Unreasonably Slow Find

Recommended Posts

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 by Guest

Share this post


Link to post
Share on other sites

Try?

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.