Yes...Linux....forgot to mention that.
Also Intel E5405 @ 2.00Ghz -- 8 processors and 32G mem in an HP Blade on local storage. System was pretty well I/O bound. Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems ________________________________ From: [email protected] [[email protected]] on behalf of Max Vlasov [[email protected]] Sent: Monday, January 16, 2012 1:18 AM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] SSD with TRIM On Mon, Jan 16, 2012 at 12:29 AM, Black, Michael (IS) < [email protected]> 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 [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
