Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only