General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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. For saving, we are using the save button from the same set.
There are no filters in the whole environment.
Awaiting your feedback.
>Clearly this can run faster!
>
>But you will have to tell us a bit more. . .
>
>1) what are you using to "search"?
>2) Do you have any filters set?
>3) what are you using to save (sounds like it could be INSERT (not INSERT-SQL)
>
>let us know.
>
>>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