Walter Meester
HoogkarspelPays-Bas
Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Milt,
>I have purchased Jim Booth book on FoxPro and want to use local views in my application. The application is not client server I am using FoxPro tables. Is there any performance benefit to using view versus set filter. Thanks
It depends..
If you're going to adress only a fraction of the table then use views. Local views are ideal for small resultsets because it makes navigation trough the resultset faster.
If you're going to adress large portions of the table(s), then use filters because the local views will take significant amounts of time to execute. Also if the filter's selectivity is low (a low percentage of the table is filtered out), you'll have no performance problems with navigation, plus the advantage of being able to use the original indexes of the table.
Walter,
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