On 21 Mar 2012, at 3:08am, Udi Karni <[email protected]> wrote: > The 240GB SSD drives are pretty reasonably priced and would suffice for > most tables. I'm just wondering how long before Flash Write Fatigue sets in > and you need a replacement. ????
Nobody knows yet. We've done a ton of tests but so far the drives which have given up are all being judged as defective, just like you get rotating drives which are defective. There's no statistical curve yet for drives of that design failing from use. It certainly does get rid of DRH's point that you can only do one write per sector for each rotation of the drive. I'm writing this on a laptop which has a 250Gig SSD in, so I have a personal interest. So far the added speed all by itself has made the extra money worthwhile. Not to mention that I can drop the laptop without worrying about damaging the hard drive surface and read/write head. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
