OSSミドルな戯れ
MySQL 5.5: :::::::::: Result Times and Averages: INSERT 100 672.442153079 4.11888 SELECT 811 673.441800291 0.332067 PostgreSQL 9.1: ::::::::::::::: Result Times and Averages: INSERT 100 2622.1109690768 23.4154 SELECT 459 2626.588798772 5.23984 SQLite 3.7: ::::::::::: Result Times and Averages: INSERT 100 550.92420354 2.83853 SELECT 502 551.120738178 0.397833
BerkeleyDB 5.1: ::::::::::::::: Result Times and Averages: INSERT 100 495.308163151 2.26031 SELECT 603 495.585024318 0.301102 SQLite 3.7: ::::::::::: Result Times and Averages: INSERT 100 522.1067024546 2.51971 SELECT 559 523.1204274229 0.335052
以下は、PostgreSQLを含むCeleron847(Dual Processor)、RAM 2GB、SDD でOSはCentOS6のマシンで、Insert/Select同時ベンチマーク実行結果である。
BerkeleyDB 6.1: ::::::::::::::: Result Times and Averages: INSERT 100 281.1365123651 0.381156 SELECT 1220 281.1340809510 0.16721 MySQL 5.1: :::::::::: Result Times and Averages: INSERT 100 299.1057975644 0.594603 SELECT 1795 299.1000098073 0.119218 PostgreSQL 9.3: ::::::::::::::: Result Times and Averages: INSERT 100 297.728115501 0.27439 SELECT 1165 297.754557170 0.188408 SQLite 3.6: ::::::::::: Result Times and Averages: INSERT 100 337.476402330 1.29092 SELECT 1931 337.627725860 0.142878