Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Write-behind caching. Still need it off?
Message
From
12/03/2005 06:48:58
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
11/03/2005 22:15:07
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00994207
Message ID:
00995129
Views:
44
>So, despite your experiences, I'd still highly recommend disabling write-caching on ANY device except one designed for full fault tolerance.
>
>Jim

I briefly experimented turning off the write-cache on my hard disks, and the computer became quite slow - I noticed this most when doing a hybernate. Sort of strange that - one should think that for hybernating, all data has to be written to disk NOW not later! Anyway, I turned it on again for performance.

One option which can be considered is to turn of the write-cache on individual disks - i.e., the disks that host the VFP database or the SQL Server database.

And where does NTFS fit in the picture? It is supposed to have transactional support, i.e., "all or nothing" is saved - but I suspect this would be more for writing individual sectors, without having inconsistent information in the file system (MFT, directories) - whereas a database will probably have to have coherent information amongst several sectors.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform