MParker Posted August 28, 2012 Share Posted August 28, 2012 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 Link to comment Share on other sites More sharing options...
Lee Smith Posted August 28, 2012 Share Posted August 28, 2012 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 Link to comment Share on other sites More sharing options...
mr_vodka Posted August 28, 2012 Share Posted August 28, 2012 Are you searching across related fields? Link to comment Share on other sites More sharing options...
MParker Posted August 28, 2012 Author Share Posted August 28, 2012 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? Link to comment Share on other sites More sharing options...
MParker Posted August 28, 2012 Author Share Posted August 28, 2012 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? Link to comment Share on other sites More sharing options...
MParker Posted August 28, 2012 Author Share Posted August 28, 2012 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. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4252 days old. Please don't post here. Open a new topic instead.
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 accountSign in
Already have an account? Sign in here.
Sign In Now