Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Using requery() in batch processing
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00204217
Message ID:
00204249
Vues:
20
>I have a parametertized view with six fields and one where condition, and nothing else. It takes about .5 seconds to requery() it. Is that normal?

I've just been timing my code, and I have a fairly simple local view of 12 fields, 2 parameters in Where, and it takes about .012 seconds each requery from a fairly small table, small result set, with indexes on Where fields, not much longer without indexes. So there's very little overhead in a Requery() command itself. Slowness may result from lack of index on Where field, large result set, network overhead, perhaps, in your case...also, index on deleted can slow it down.
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform