Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
10 Things to Avoid in VFP Development
Message
From
31/12/1999 12:09:29
Walter Meester
HoogkarspelNetherlands
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00310318
Message ID:
00310937
Views:
38
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,
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform