Larry,
I am slowly learning the RULES about Indexes. I have been reading the threads and realize there are rules as to when RBASE will optimize the searches. I do not always understand it all, but am keeping the threads for future use. Thanks for the tip. I will implement on the real menu using the LIKE instead of CONTAINS. Hopefully that will help with the speed. Jim ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Lawrence Lustig Sent: Friday, February 12, 2010 10:24 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: ON KEY PRESS << Since they are long text names, should I still index them? I just changed the WHERE to use LIKE instead of CONTAINS. It is hard to tell from here (off site) but it seems faster. >> CONTAINS will never use an index, so if this search is the only reason you're indexing the columns you can safely remove the indexes. If you want an indexed search, you must use LIKE and make sure that there is no wildcard at the beginning of the string. -- Larry
