Short term solution: use SET KEY
Long term solution: parameterized views.

>I have a SET FILTER command before I display my grid and it takes long time to the grid to display the info., when there are a few records that match the filter.
>
>Can someone give me some suggestions to improve the speed in the grid?
>Any comments are welcome, thank you in advance.
>
>Morys