Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
10 Things to Avoid in VFP Development
Message
De
31/12/1999 12:09:29
Walter Meester
HoogkarspelPays-Bas
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00310318
Message ID:
00310937
Vues:
37
Jim,

>SET FILTER whether optimized or not , is slower than no SET FILTER. Speed is a relative consideration not an absolute.

Yep it is, BUT (you knew there was a but), When you do allow users to filter (large) tables, where you cannot live with SQL-views. SET FILTER is a handy tool. When optimized, it's far faster than using views. You might use SET KEY, to filter the table, but I want to allow users to define their own filter.

For example I've got a persons inputform, which users can filter either on, name, adress, city, gender, age, etc.. or any combination of those. It's true that this *CAN* be slow, but that's the problem of the users, He/she either get's it slow or not at all. The form is primarely used for maintaining data, but they can also pick out a user from a grid. This grid CAN be filtered. This way, there is definitely a place for filters.

Walter,
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform