Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SET FILTER Command
Message
From
24/05/2002 11:55:20
Mike Yearwood
Toronto, Ontario, Canada
 
 
To
24/05/2002 11:47:16
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00660922
Message ID:
00661103
Views:
52
Hi Hilmar

Its better to say a filtered grid may be slow. It depends on the filter, the number of records in the table, the number of rows in the grid and the number of records returned by the filter.

No solution is perfect.

>>You're quite right, but the grid is the fastest object i know to display data and combinated with a textbox for search it's a ergonomic way to provide data to users.
>>
>>Roman
>
>Well, what I mean is that, AFAIK, a) A filtered grid is slow. b) A grid with a parameterized view is fast - unless the parameterized view fetches a lot of data for a specific key value. Which seems to be precisely your problem.
>
>One possibility is to show the users all data that start with a certain letter(s) - using this as the view's parameter, or one of the parameters.
>
>If the user types only a single letter (or none at all!) and then presses a "Show" button, he will have to put up with a longer loading time. That is, users should type at least one, better two or more, letters, most of the time.
>
>Hilmar.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform