fmp7_user_fmp7fmp7 Posted February 16, 2005 Share Posted February 16, 2005 Is there any way to make a search on unindexed field so that the search does not take an hour? I have a database of 40k records and I have to search a calc field(unindexed). I have tried to do a set field of the calc field with a regular number field but the setting of the field takes about as long as doing the find. Does anyone know how to help? Thanks Link to comment Share on other sites More sharing options...
Reed Posted February 16, 2005 Share Posted February 16, 2005 If it's not possible to index the calc field, and it's because it's referencing related data, could you set the field up as a lookup or an auto-enter calc that is stored. Then you'd be able to index it and speed up the search. You just have to make sure that the field stays up to date by controlling how it's updated. If you could post the file (just save a copy as... clone (no records)) I could see how the calc. field is set up. Dana Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7009 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