Jim, I use an adapted selection method based on Razzak's example from last year which gives me a slightly wider coverage across two columns from a table of 41336 rows which is too fast for me to see any delay (v7.6).
The two columns are indexed with a concatenation of them both having a unique constraint. The display of selected records on key press is, as said, all but instant. Regards, Alastair. From: Jim Belisle Sent: Monday, January 11, 2010 5:42 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: ON KEY PRESS Jan & Larry, I do not have indexing on any of the fields. Being a novice at programming, I watch the list when questions come through on indexing and am confused as to when to use them. It seems in some instances the list says not to use them and in other use them. I will have to try that. Jim ------------------------------------------------------------------------------ From: [email protected] [mailto:[email protected]] On Behalf Of Lawrence Lustig Sent: Monday, January 11, 2010 11:38 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: ON KEY PRESS << I am using the On key press feature to edit orders. The orders table has 20,000 plus rows and it is taking ten seconds or more for each keystroke to search the records. What can I do to make the process faster? I just updated to the latest 7.6. >> What is the search you are executing in the ON KEYPRESS event? If it's non-indexed, expect it to take a few seconds. -- Larry ------------------------------------------------------------------------------ No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.725 / Virus Database: 270.14.134/2613 - Release Date: 01/11/10 07:35:00
