Try this experiment:

Launch Windows Task Manager and add 'Page Faults' to the normal list of columns that are displayed (by choosing View ... Select Columns from the menu).

Launch VFP. Open a table having 325,000 records or so.

Run a non-Rushmore optimizable SQL SELECT query from the command window.

On my machine, just launching VFP resulted in 1948 page faults. Running the query resulted in 37,102 additional page faults!

I tried the same thing in VFP6 SP5, and got approximately the same results.

Is this normal?