>
>Write caching is controlled at the OS level. If there is a problem with cache coherency in a write-behind controller, you'll see it in ALL apps that write to disk, not just file-based databases. Conversely, if it's working properly, it'll be fine for all apps.
That's not completely true. Take Word for example. User opens a Word document, modifies it, and saves it. It is a rare that a second user will need the Word document immediately. Because of the way database applications are used, the caching is much more apparent.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer