David,
I'm sure Ed Rauh can come in here with much better couple of page description about this.. but a page fault is just a request for a memory page that isn't in RAM so it has to get it from the swap file. It's a rather normal thing. Have you looked at page faults while doing everything on your computer? loading a large document into word or excel? using your email client?
>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?