Hi, The speed test result is obsolete
http://sqlite.org/speed.html Here is my results. http://www.ohgaki.net/download/speedtest.html http://www.ohgaki.net/download/speedtest-pgsql-nosync.html The later one is without fsync for PostgreSQL. All dbmses are tested with default rpm package settings. ---- CPU AthlonXP 2500+ HDD ATA133 7200rpm Memory 1GB Memory OS MomongaLinux1/kernel-2.4.27-4mk7/glibc-2.3.2-13m PostgreSQL-7.4.5-1m MySQL-4.0.20-4m SQLite-2.8.13-1m ---- To be fair to PostgreSQL, 'vacuumdb -a -f' is executed after each test. These dbms packages are little old... Latest releases are PostgreSQL 8.0.1 MySQL 4.1.9 SQLite 3.0.8 Result may change with latest versions, but my result should be more acculate. Regards, -- Yasuo Ohgaki
