On Mon, Jan 16, 2012 at 12:29 AM, Black, Michael (IS) < michael.bla...@ngc.com> wrote:
> > On SSD with 16384 page size and no WAL mode: > > time sqlite3 gen.db <gen.sql > > real 4m4.816s ... > Note: Database is only 595M with this page size. Much more efficient > storage may explain most of the time difference. > ... > > On hard drive with 16384 page size and no WAL mode (now you can see the > SSD latency advantage): > > time sqlite3 gen.db </mnt/ssd/gen.sql > > real 17m18.919s > > Michael, thanks for the info, your tests confirms some advantages of ssd, at least on some of the current platform (linux, can you confirm?). Probably the page size is a parameter that also should be adjusted for optimal performance. I suppose it can be different for different ssd models, but it's just a guess. Max _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
