Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SET FILTER Command
Message
 
 
À
24/05/2002 13:25:19
Mike Yearwood
Toronto, Ontario, Canada
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:
00661183
Vues:
68
>Hi Nadya
>
>Users don't complain unless they've had something faster before. That doesn't mean you should not improve performance.

I agree with you. I think, we should re-design our framework to allow it to work with views and also find out, how we can create views on the fly with variable condition.

May be it would be a stage 2 problem, I don't know... Right now my manager would not authorize any changes...
>
>The scrollbar is unaware of the filter, as is the grid <g>, it only shows the number of records.
>

Ok, I didn't know this... Now I know how to explain this weird scrollbar behavior...

>>Hi Hilmar,
>>
>>I confirm, filtered grids are slow. Especially when only few records in a table satisfy the criteria. Say, you have 20000 records. Only 20 are problematic and you want to show them in the grid. It's very sloooooooooow...
>>
>>Unfortunately, our own framework is not build to support views. I have some ideas how to fix the framework, but users didn't complain (may be they are very patient), so we didn't really looked into any alternative solutions...
>>
>>I also noticed the problem with ScrollBar and discussed it, but didn't get a responce... Scrollbar doesn't behave correctly. I didn't realize, it might be related with a filter...
>>
>>>>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.
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform