Microsoft has an interesting article on hard drive caches re: SQL Server: http://support.microsoft.com/kb/234656
"Many disk drives (SATA, ATA, SCSI and IDE based) contain onboard caches of 512 KB, 1 MB, and larger. Drive caches usually rely on a capacitor and not a battery-backed solution. These caching mechanisms cannot guarantee writes across a power cycle or similar failure point. They only guarantee the completion of the sector write operations. As the drives continue to grow in size, the caches become larger, and they can expose larger amounts of data during a failure. " On 6/1/09, John Stanton <jo...@viacognis.com> wrote: > Simon Slavin wrote: >> On 31 May 2009, at 11:56pm, John Stanton wrote: >> >> >>> Try studying basic database theory and technology to get a better >>> understanding of the problem. >>> >> >> I have a pretty good understanding, I think. Plus 25 years experience. >> > Is it 23 years experience or 1 year 23 times? This forum is to share > information on Sqlite, for mutual advantage, not get into pointless > arguments. Let us keep it that way. > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Software first. Software lasts! _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
