Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SET FILTER Command
Message
De
24/05/2002 11:55:20
Mike Yearwood
Toronto, Ontario, Canada
 
 
À
24/05/2002 11:47:16
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00660922
Message ID:
00661103
Vues:
54
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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform