>As for buffering on the server, never...ever... use write caching on the server unless the disk controller is specially designed to work with databases. This advice is not just for Fox data. I've been reading SQL Server Books Online lately and that warning is all over in there.
In your experience, what are the drive controller manufacturers whose products have been "specially designed to work with databases"?
It's a bad idea to extrapolate SQL Server to all back-end or file-server databases. All applications, not just databases, are supposed to delegate file I/O to the OS; most have no other choice. However, SQL Server enjoys a (too?) close relationship to NT/W2K and uses a lot of tricks to improve performance. It's not surprising the SQL Server docs are littered with warnings.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up
