Thanks! I got one and tried - and it seems to improve overall performance about 2X. Very cool.
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. ???? On Tue, Mar 20, 2012 at 2:27 PM, Roger Binns <[email protected]> wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > On 20/03/12 13:59, Udi Karni wrote: > > And a more general question. My PC has 8GB of RAM. I am considering > > getting a much larger machine that can take upwards of 100-200GB of > > RAM. > > I'd recommend getting one or more SSDs instead (also a lot cheaper). The > reason is that during your vacuum most data is only read once so RAM won't > really help - instead you want improved latency and throughput of reads. > > For RAM you should make it a little larger than your working set of data. > That will depend on your workload and app, and applies to any kind of > database. Again SSDs will help since the penalty of a RAM/cache miss is > less than with spinning media. > > Roger > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.11 (GNU/Linux) > > iEYEARECAAYFAk9o9ksACgkQmOOfHg372QRIygCgrCnBL5osiqWR+W1bHjLgDwZZ > VAoAoN0gKsJU35myHrlFEerHwLnXjyjY > =yAEn > -----END PGP SIGNATURE----- > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
