Lots of talk about filtered grids being slow. Most people that use a table set a filter and naturally want an order set. I set the order and filter in a form and added 2 buttons. One to display a browse and another to display a grid. The browse was instant and the grid was extremely slow. Something that goes back as far as Foxpro's beginning is that executing a GO TOP on an ordered and filtered large table creates a huge delay. So I started using LOCATE without any parameters instead of GO TOP to make sure that I was at the top of the filtered set of records.

With LOCATE the browse appeared instantly. The GRID was slower and when I would use the vertical scroll bar to go up beyond the first record and then had a huge delay like the computer froze. I started looking into the code that microsoft wrote to display the base class of a grid and found multiple GO TOP commands and GO BOTTOM commands in the base grid code.

If Microsoft would have just used LOCATE instead of GO TOP, I really believe that Grids would be fast. I had to move to views in order to make the grids fast and alert the user if they are asking for a result set that will return a lot of records.