-----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
