Mensaje
De
25/06/2001 14:05:14
a
25/06/2001 10:31:00
General information
Foro:
Visual FoxPro
Category:
Formularios & Diseñador de formularios
Título:
Re: Set filter
Miscellaneous
ID de la conversación:
00520806
ID del mensaje:
00523095
Views:
22
>>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.
>>
>>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.