Walter Meester
HoogkarspelPays-Bas
Bob,
First off, i'm with you. filtered grids can be slow but there are certainly cases where the P-view option is even slower.
So, if in your case filtered grids seem to be the best possible way, the following tips may be valuable.
1. Make sure the filter is optimizable by rushmore.
2. If the filter can be predetermined (like filter out all discontinued products, all female contact persons or whatsoever) you can use filtered indexes like
INDEX ON ArticleNo FOR !discontinued.
3. If this is not the case you can use the SET KEY TO command (see help) to filter out indexed values.
4. If you're programmictly navigating in the filtered grid, LOCATE is much faster GO TOP as it uses rushmore to optimize the query. a SKIP can be replaced by a LOCATE NEXT 1 and CONTINUE.
HTH
Walter,
>I know I have read somewhere but cannot I cannot remember
>what the workaround was on how to avoid the horrible
>time delay that results when you scroll to the top
>or bottom of a filtered grid.
>Any ideas ?
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement