[RBASE-L] - Re: ON KEY PRESS

[Michael J. Sinclair]

Put an index on the field(s) that are being selected by the OnKeyPress...it works like lightening. Also, if you have the code that was offered originally the Rbase User that created it, I found some parts of the code did not work or generated errors which slowed it up a bit. I found them by tracing the application. You should do the same so you can see which line or lines are causing the delay.
Mike

 

-------------- Original message from "Jim Belisle" <j...@kaypark.com>: --------------

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: rbase-l@rbase.com [mailto:rbas...@rbase.com] 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