On 20 Sep 2011, at 2:07pm, Richard Hipp wrote: > That's the usual scenario with spinning media. I'm less familiar with the > internal workings of flash memory controllers. But people tell me that they > fail in similar ways.
Yes yes and yes. With normal settings set, SSD storage controllers lie to the OS in the same way: once it has accepted the new write commands it acknowledges them as written immediately rather than saying "Hold on while I do that.". Most bulk storage devices apart from the cheapest do have pin settings (or tiny switches, or some hardware equivalent) which defeat this. That makes them act properly and not acknowledge writes until the data really has been written. However, you would not want to use storage set up this way as the boot drive for a computer. It makes a huge difference in write latency. I set up a desktop computer to work this way as a demo on information security and it took three times as long to boot as normal and everyday operations like typing in Word slowed down something like fivefold. Really painful to use. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
