Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Curiousity on a Wish rating
Message
De
09/02/2003 18:48:50
Gerry Schmitz
GHS Automation Inc.
Calgary, Alberta, Canada
 
 
À
09/02/2003 18:24:13
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00748446
Message ID:
00751228
Vues:
26
>Yes, after reading your other regarding SQL Server I'd certainly feel comfortable with CreateFile/FILE_FLAG_WRITE_THROUGH. Then FLUSH wouldn't matter.
>I was reticent earlier (still am, a teeny bit) because of performance impact, but if its good enough for SQL Server...

To be on the safe side, FILE_FLAG_WRITE_THROUGH should be an option that you turn on or off (at an application and/or file level), in which case you would still need a FLUSH.

SQL Server does some of it's own "caching" before "writing", much like VFP would do when using TRANSACTIONs.

In a predominately OLTP environment, FFWT would make things simpler.

In a predominately (high-volume) "batch" environment, that did NOT use TRANSACTIONs, there might be a performance problem with FFWT (as your earlier FLUSHING tests may have indicated).
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform