Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to know VFP really fetch view records as needed?
Message
De
01/01/2000 13:15:48
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
How to know VFP really fetch view records as needed?
Divers
Thread ID:
00311189
Message ID:
00311189
Vues:
93
Hi,
I have set myview cursorsetpro("MaxRecords", 10, "VIEW2")and cursorsetpro("fetchasneeded", .t., "VIEW2"). How could I know it really fetch as needed?
my table has 1,000,000 records and added into DE in my form. I found that, it is much faster if I load whole table (<> 1 seconds)compare with query (>44 seconds). I have set sys(3045,1) and the cursorproperty as above.. why still so slow?

Thank you
I am not the most powerful man in this world.
I am not the worst man in this world either.
I just as same as all of you.
I still need to learn from my mistakes...
Répondre
Fil
Voir

Click here to load this message in the networking platform