Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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?
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement