Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
I have a local view thats acting like a dog and I cant figure out why. The project is on a local c: drive and needs to access a table (which I placed into the project) on a server drive.
The local view I created is supposed to give users the ability to see all the names (which may repeat) of employee's transactions. The field is char 40; I created an index on the field (name) to help the query - vfp put the index on the server drive. The query takes several seconds to open and the table has only 3200 records. What am I doing wrong? Should I move the index locally?
TIA
CG
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