Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Wishlist: native VFP views
Message
 
 
À
19/12/1999 03:37:14
Walter Meester
HoogkarspelPays-Bas
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00305642
Message ID:
00305898
Vues:
30
Walter,

I really don't use large views. Editable views are parameterized so usually the size in the tens of rows, maybe a couple of hundred at most. Read-only views that are large, for reports etc., don't really compare to xbase dml. By time you set relations, scanned and inserted records to the result you are better off with one or two SQL commands IMHO.

>You've got just to load the VFP-view and doesn't execute the relations and filter setting for those records you don't access, giving you a tremendous performance gain over very large SQL - views.
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform