On 11 Jun 2009, at 16:19, Jim Wilcoxson wrote: > SSD's usually have poor write performance, because to do a write, they > have to use read, erase, write sequences across large blocks like 64K. > Most of the SSD benchmarks that quote good write performance are for > sequential write performance. If you skip all over the disk doing > small writes, like a database does
I think it's not the case that a database needs to skip all over the disk. For a start you can write to a log at the DB level, but even if you don't at least some modern filesystems are copy-on-write, so they never actually rewrite blocks (well, they do, but not in the read- modify-write sense). ZFS is one such filesystem. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users