On 9 Apr 2018, at 8:41am, Pavel Cernohorsky <pavel.cernohor...@appeartv.com> wrote:
> 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. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
