Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Set filter
Message
 
 
To
25/06/2001 10:31:00
Patrick O'Neil
American Specialty Information Services
Roanoke, Indiana, United States
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Miscellaneous
Thread ID:
00520806
Message ID:
00523095
Views:
19
>>Moises,
>>
>>You should only use filtered tables and grids if you have very small number of records total on the order of a couple of hundred rows. Beyond that the performance of the grid will truly suffer. You will also have to deal with the vertical scroll thumb will not go all the way to the top or be sized relative to the number of rows. Parameterized views do not suffer these problems.

>are you saying that if i am outputting a report from a table
>with (say) 358 thousand records, that performance will be better if i
>base the report on a parameterized view of that table as opposed to setting
>a filter on the table and using the table itself ?

Patrick,

No. I highlited the part of the message above where filters do not work well. Filters on all but small tables displayed in grids perform miserably.
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform