General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi Richard
By search do you mean a grid? In any case, try using SET KEY.
Is this a problem with other tables?
Geoff
>Sorry for taking too long to get back to you. I was still concentrating on other problems that have now been solved. Back to my problem:
>
>To search, we are using the find button created from the wizbtns class among the other navigation buttons. The field by which we are searching is a regular index and I have also tried destroying and rebuilding the index to no avail. I did not wipe out the cdx file. I only stripped off the index, saved changes, went back and recreated them. Is this enough? For saving, we are using the save button from the same set.
>
>There are no filters in the whole environment.
>
>Awaiting your feedback.
>>Just some thoughts. Let us start with "search".
>>1. "Reindex", it should be done from scratch. Remove index file and recreate it.
>>2. How do you perform "search"? Is it seek(), seek ..., or indexseek()? Does it depend on the method of searching?
>>
>>
>>>SOS Folkes!
>>>
>>>I have a multiuser system that is becoming too slow on searches and saving. The database is setup with code implied relationships. However, this is not the problem because, for example, there is a simple screen that looks only at one table that has around 52,000 records. It takes about two minutes to search and another three to save!!! I have tried packing, reindexing... to no avail. ANY IDEAS?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only