Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Set Filter performance in Browse versus Grid
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00279680
Message ID:
00280856
Views:
15
>David,
>
>Slowness of Grids objects with the SET FILTER command in not a matter of perception. ( each record is evaluated before the Grid show the first matching record ! )
>
>Believe me.
>
>Marcel

Marcel,

This nis puire conjecture for me. I ahve observed some strange interactions between grids and forms especially when using a combo within the grid. This behavior leads me to suspect that grids track their recordsource independent of the form's data session.

If the above is true, then a grid has to evaluate its entire record set before it can begin to present any records to the user, thus a set filter is slow. A browse simply puts a display on the data in a work area outside the browse. Therefore a browse does not need to process all of the records before showing the visible ones.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform