Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Set filter slow my operation
Message
De
26/07/2004 10:21:07
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
À
26/07/2004 04:33:08
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00927837
Message ID:
00927913
Vues:
25
>hi,
>thank you,
>it works,
>but i think it take same time.
>
>regards.

If your filter is:
SET FILTER TO char3=thisform.combo1.value
Then I assume that char3 is a field in the table.

In this case, you should have an index with the expression char3. This will make both a filter and a query faster, if they use this field for a condition.

For more details, search the help file for "Rushmore Optimization".
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform