Hello drh, There's nothing in MSDN about it only applying to SCSI drives.
I believe what you're seeing is that the "Disk Drive Cache Flush" command is ignored on IDE drives (specific command to the disk drive itself) but, that doesn't mean the OS isn't flushing the data to disk instead of leaving it in the OS disk cache (Microsoft calls it the "Intermediate Cache"). It's likely just as ignored when you use "FlushFileBuffers". C Saturday, January 28, 2006, 9:47:55 PM, you wrote: dhc> Nono BEZMan <[EMAIL PROTECTED]> wrote: >> >> My point was that there is light for windows users, if >> this >> FILE_FLAG_WRITE_THROUGH flag is added to the code. >> Otherwise, it seems that >> FlushFileBuffers really hinders SLQite to a point it >> becomes unusable. '7 >> Inserts per seconds' on a brand new AMD64 3500+ with >> SATA drives is extremely >> low, and this could be fixed by using this option, >> IMO. >> dhc> A quick google of FILE_FLAG_WRITE_THROUGH shows me that dhc> this option is a no-op for SATA drives. It only makes dhc> a difference on SCSI disks. So it seems your patch dhc> is really just the equivalent of setting synchronous=OFF, dhc> at least on your brand new AMD64 with the SATA disk drives. dhc> -- dhc> D. Richard Hipp <[EMAIL PROTECTED]> -- Best regards, Teg mailto:[EMAIL PROTECTED]
