Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Filter very slow
Message
De
12/08/1997 18:35:30
 
 
À
12/08/1997 11:30:39
Larry Long
ProgRes (Programming Resources)
Georgie, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00044161
Message ID:
00044359
Vues:
35
What do you mean with the point 2)?

Vlad

>Whenever you set filter you need to...
>1)Ensure that you have an index on the field you are filtering
>2)set order to 0, otherwise you essentially get 2 filters fighting each other
>3)if you have set deleted on, you should have an index on deleted(), something like "INDEX ON DELETED() TAG ISDELETED"
>
>In most cases it is better to use an SQL Cursor for most filters.
>
>Hope this helps //:^)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform