>>Is there an easy way to speed up a grid which displays a filtered table? It is extremely slow, no matter how fast the computer is.
>Jon,
>
>Be sure the filter is fully optimizable
>
>Better still use a parameterized view to populate the grid.

The grid works at a tolerable speed... until the first record in the filtered set is reached. At this point, if the user scrolls up using the scroll bar or press the up arrow - anything to try to move before the first record - the computer will just hang for about 20 seconds or so. It seems that just the first record is problematic.

I will check the filters again, just to make sure they can be optimized.

The parameterized view might be a possibility, too, although there would be a lot of parameters in this particular instance.

BTW, I'm doing this in VFP 3.0b if that makes a difference.