Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>Thanks for the lowdown.
>
>The tables actually don't have many deleted records so I think I can assume I won't run into any major performance issues.
>
>Although saying that - any performance increase is good, so I may consider putting that index on all tables, after all, it only requires a few extra megs here and there.
>
>Kev
Kev,
The performance hit isn't from having the index, it's from FoxPro retrieving the index across the wire when you access the table. Without the index it goes right to the records you need, gets them, and then checks those few locally for their DELETED status.
The best thing for you is to read the FPA article from last Spring about 4 times! ;-)
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