Subject | Slow Lookup |
---|---|
Author | Uwe Oeder |
Post date | 2003-11-19T09:37:45Z |
Has anybody encountered anything similar. My application does a lookup on a
text field every time the user types something. However the lookup is
really slow , to what it was previously in with BDE so I added buffers to
my database and ASCENDING indexes on all fields that have a lookup. No
speed change detected. So I added DESCENDING indexes and the wait time
decreased by a half. Is there anything I can do to make the indexes make
the lookup even faster ?
text field every time the user types something. However the lookup is
really slow , to what it was previously in with BDE so I added buffers to
my database and ASCENDING indexes on all fields that have a lookup. No
speed change detected. So I added DESCENDING indexes and the wait time
decreased by a half. Is there anything I can do to make the indexes make
the lookup even faster ?