Jan, >>> I could use something like %LIKE% to accomplish the same. <<< Indeed, you can always use something like: .WHERE your_column LIKE '%test%' And it will search for the string "test" in the entire column value. I use this construct all the time by prompting the user: 'Type part of the description.' And then, by using the multi-wildcard on each side of the text, I can search the entire column string. This works great for search of description columns where the user knows only a key word, rather than the entire description. Javier, Javier Valencia, PE 913-829-0888 Office 913-915-3137 Cell 913-649-2904 Fax _____
From: [email protected] [mailto:[email protected]] On Behalf Of jan johansen Sent: Friday, February 12, 2010 10:50 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: ON KEY PRESS Jim, I too am still learning about the use/non-use of indexes. I indexed the columns that I wished my CONTAINS to use and they did work faster so I am unclear on Larry's comment. I moved away from LIKE because I wanted to be abel to search anywhere in the column for the text value. That being said it looks like I could use something like %LIKE% to accomplish the same. I can't remember if you ever mentioned your hardware. Because R:Base is "bigger" now, the hardware needs to grow up as well. I still have a one computer with a 100MBS card in it that I use for testing. If I can make my queries run fast on that I am satisfied that the 1GBS network will be great. Jan -----Original Message----- From: "Jim Belisle" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Fri, 12 Feb 2010 10:29:16 -0600 Subject: [RBASE-L] - Re: ON KEY PRESS 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
