On 14 Feb 2011, at 10:30am, Max Vlasov wrote: > On Mon, Feb 14, 2011 at 12:05 PM, Simon Slavin <slav...@bigfraud.org> wrote: > >> Can you expand upon your conclusion ? I like your test, and am interested >> to know precisely where you think the lag is happening. > > Simon, the conclusion came from the assumption that if the lag is at the OS > level then unplugging usb cord from powered hd box should also lead to bad > results, but it doesn't. I.e. only in case of keeping power for unplugged hd > box, the last commit reported by sqlite as successful is actually written. > So looks like windows takes very seriously the option "optimize for quick > removal" for removable drives. But both examples show that the drive itself > doesn't obey this option. On the other side SATA/PATA drives connected > directly to the motherboard have option "enable writing cache" that is > explained like hardware-only option, maybe in this case one can actually > affect how the drive is responding, but in contrary to usb tests, these ones > are harder to make.
Okay. Nice piece of work. simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users