Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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?
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