Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP generates 37000 page faults per query--is this norma
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
00649779
Message ID:
00649783
Vues:
17
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?
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform