Between updates, automatic maintenance, registry churn, event logs, and background "optimisations" I reckon windows could give 400G/day a run for its money :P
-Rowan On 19 June 2018 at 12:37, Keith Medcalf <kmedc...@dessus.com> wrote: > > The new "consumer" SSDs from Samsung carry a 1200 TBW/8 year warranty on a > 4 TB device. That is a lot of writing for a "consumer desktop" computer > ... that is about 400 GB written per DAY every day for 8 years! > > --- > The fact that there's a Highway to Hell but only a Stairway to Heaven says > a lot about anticipated traffic volume. > > > >-----Original Message----- > >From: sqlite-users [mailto:sqlite-users- > >boun...@mailinglists.sqlite.org] On Behalf Of Scott Doctor > >Sent: Monday, 18 June, 2018 22:27 > >To: sqlite-users@mailinglists.sqlite.org > >Subject: Re: [sqlite] Strange Corruption Issue > > > >SSD's have a limited number of write cycles. You may have a > >failing SSD. Those are still, IMO, another 5-10 years before > >they solve the write lifetime reliabilty issue. > > > >------------------------- > >Scott Doctor > >sc...@scottdoctor.com > >------------------------- > > > >On 6/18/2018 20:15, Patrick Herbst wrote: > >> I'm using sqlite in an embedded application, running on SSD. > >> > >> journal_mode=persist > >> so that it is more resilient to loss of power. > >> > >> I'm seeing corruption. I'm using sqlite to log events on the > >system, > >> and the corruption is well in the middle of a power session; not at > >> the tail end of log when a power loss might occur. > >> > >> What i'm seeing is just a few pages corrupted with random bits > >being > >> flipped. looking in a hex editor I can see the corrupted data, and > >> where I can tell what values it SHOULD be, I see that they're > >wrong, > >> but only by a single bit flip.... in random bytes here and there. > >for > >> example a "A" is "a", or a "E" is "A". These are all changes of a > >> single bit. there are far more examples... but in pretty much > >every > >> case (even when RowID's are wrong) its just off by a bit. > >> > >> I'm using sqlite 3.7 (i know, old, but this this system is old). > >Has > >> anyone else seen random bit flips? Any idea what could be causing > >it? > >> _______________________________________________ > >> sqlite-users mailing list > >> sqlite-users@mailinglists.sqlite.org > >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite- > >users > > > >_______________________________________________ > >sqlite-users mailing list > >sqlite-users@mailinglists.sqlite.org > >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users