On 9 Apr 2018, at 8:41am, Pavel Cernohorsky <pavel.cernohor...@appeartv.com> 

> if you use bigger pro-level SSD, you get on a bit less that 1 year.. still 
> not good enough. Of course, big unknown in this is the constant representing 
> the ability of the SSD controller to merge requests and minimize block 
> re-writes.

If you compiled SQLite with standard options, and have the correct settings for

PRAGMA fullfsync  (Macintosh only)
PRAGMA journal_mode
PRAGMA synchronous

then SQLite tells the operating system all the correct things.

Whether the operating system, the storage driver, and the storage subsystem 
itself do the right things is out of control of software.  Not only can you not 
tell what's being done, but it can change with what looks like a minor change 
in driver or hardware.

sqlite-users mailing list

Reply via email to