Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Vfp50 - VIEW or SET FILTER - which is best?
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00025400
Message ID:
00025725
Views:
34
>>>>>>Which is better to do?
>>>>>>A VIEW or a SET FILTER...
>>>>>
>>>>>Well, you can do both at once, too...but often you want to use a view when you have two or more tables combined for one grid, so you can't use set filter for that, only a view will work. Set filter is a more all-purpose command for tables, not only for grids...it really depends on exactly what your needs are, what you use...
>>>>
>>>>with answers like that you risk losing your anonymity.... sounding more like a professor than a bureaucrat...
>>>
>>>Uh-oh...well, I could change my moniker to 'the eloquent professor' (s)
>>
>>Yes, but you'll still miss the Beethoven style hair... :-)
>
>Well, perhaps we can airbrush my picture... :~)


I agree use a view, but I have a comment reguarding one person who said views are faster. I am not sure. Efficient use of views requires the correct indexes. I understand that set filter is Rushmore optomizable, so with the proper indexes it could be just as fast
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform