Jump to content
Sign in to follow this  
MParker

searching database sloooooooooowly

Recommended Posts

ok, i'm not exactly a noob when it comes to filemaker, but this one is throwing me a curve ball. i've got a fairly massive database. roughly 12k records and quite a few fields. i'm switching the entire database over from MS Access to Filemaker. it's be a year long project to get this thing ready before i roll it out to the company. now, i'm very very close to finishing and so i decided to load all of the actual data in from access and everything worked perfectly. but here's the downside....when i search, it takes (very literally) about 1 and a half minutes to come up with a result. now, ms access doesn't take but a split second to search the same data. so, am i doing something wrong? is there some setting i need to check? i've got the main searched fields indexed....but that's about all i know to do. any help would be GREATLY appreciated. because as of right now, if i can't get this problem fixed....1 year of work is going down the drain.

oh, i should probably mention, i'm running this database from a fmp server

Share this post


Link to post
Share on other sites

The number of records isn't that large. However, I believe some of this slowness is caused by FileMaker creating its indexes. This is something that FileMaker does when you first perform a find (and later when it is needed) .

Other things may be coming into play, but that is the most common.

Lee

Share this post


Link to post
Share on other sites

Are you searching across related fields?

Share this post


Link to post
Share on other sites

yes, there are related tables in there, but it looks like the actual lag is right when you start the search. basically, you go into find mode, and select one of the text fields and start typing. nothing shows up as you type and it takes about a minute before the characters actually show up on screen, then you are able to preform the search and from the point (navigating around and going to different layouts) it's relatively fast. so, it's just when you start the find process. now, i'm not sure what that means, but surely....that's not 'acceptable', right?

Share this post


Link to post
Share on other sites

ok, i have cleared all indexes and it seems to have gotten a lot better. it's now down to 13 seconds wait time. still completely unacceptable, but definitely a huge difference.

The number of records isn't that large. However, I believe some of this slowness is caused by FileMaker creating its indexes. This is something that FileMaker does when you first perform a find (and later when it is needed) .

Other things may be coming into play, but that is the most common.

Lee

so, is there a fix for this? i've already cleared all of the indexes in the main table. should i clear them in all related tables too?

Share this post


Link to post
Share on other sites

D'OH! i think i found the culprit. it was the autocomplete using existing values. that was definitely a convenient feature, but it takes waaaaaay too long. i'm guessing nobody knows of a way to fix that issue huh? i turned it off for that field and it's an instant search now, so that was definitely the problem.

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.