Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Using requery() in batch processing
Message
De
01/04/1999 09:42:54
 
 
À
01/04/1999 09:30:22
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00204217
Message ID:
00204224
Vues:
17
>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?

Is this a local view? If so, make sure that the expression in the WHERE clause match an index. An index on Deleted() can help you on some occasion too.

>Do most people just make normal views when they are processing records in batch and then use for condtitions and filters to limit the current data set?

If the table is small or it's a rare query, yes. If the table is big or the query will be performed many times, it will be faster to create more specialized views.

HTH
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform