Yeah Jan, Having a minimalist computer for testing has always been a favorite of mine, when I had that freedom.
That has not been the case of late, so my methods have changed. I test on a local copy of the app, and attempt to get everything to happen instantly. The faster it goes, the less resources it is probably using. I have a network copy of the database to make final speed tests, when all the bugs are worked out. Dennis McGrath ________________________________ 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
