For the moment, this is just a dump of some BayesBenchmark results. Eventually, I'd like to fix up this page so others can easily add their benchmark results resu\
lts for different setups and backends.
All numbers are the average for three runs of the benchmark (except the PostgreSQL fsync=false run, it took too long in the first place). All times are in seconds.
...
- Berkeley DB - 4.3.x
- MySQL - 45.10.710
- PostgreSQL - 8.0.1 3 (with pg_autovacuum running every 60 seconds)
Everything ran local to the box
- Run using Mail-SpamAssassin 3.1.0-RC1 release SDBM numbers are from an experimental patch to SA that will hopefully be available in trunk soon
Phase | SDBM.pm | DBM | SQL.pm | MySQLBRMyISAM]InnoDB | PostgreSQL[ | .pm | MySQL.pm | PgSQL.pm | PgSQL.pm | |||||
1a | 82.88 | 120.10 | 399.55 | 429.00 | 1229.08 | 4445 | ||||||||
1b | 65.83 | 98.41 | 261.20 | 279.71 | 919.98 | 3051.50 | ||||||||
2 | 497.33 | 1151.58 | 743.53 | 784.08 | 1357.86 | 5664 | ||||||||
3 | 14.03 | 40.03 | 9.23 | 6.74 | 6.42 | 9.10 | ||||||||
4a | 35.25 | 65.06 | 288.81 | 369.57 | 429.12 | 2082.32 | ||||||||
4b | 28.27 | 46.61 | 241.51 | 301.66 | 343.07 | 1122.40 | ||||||||
5a | 261.14 | 803.19 | 481.69 | 517.21 | 948.10 | 4304 | ||||||||
5b | 174.01 | 358.67 | 222.93 | 232.79 | 420.74 | 1128.28 | ||||||||
86.12 | 124.94 | 375.97 | 163.92 | 184.65 | 164.23 | 222.54 | ||||||||
1b | 87.68 | 142.01 | 352.76 | 159.77 | 170.67 | 154.03 | 211.93 | |||||||
2 | 530.39 | 1555.36 | 872.14 | 663.12 | 682.71 | 929.31 | 1149.92 | |||||||
3 | 18.38 | 49.47 | 9.18 | 9.34 | 9.78 | 6.79 | 8.69 | |||||||
4a | 36.82 | 61.56 | 218.99 | 146.36 | 377.80 | 202.19 | 253.36 | |||||||
4b | 37.14 | 60.23 | 201.49 | 146.36 | 381.26 | 196.09 | 242.49 | |||||||
5a | 273.90 | 902.26 | 547.98 | 364.13 | 380.06 | 507.15 | 710.41 | |||||||
5b | 193.95 | 443.86 | 284.70 | 228.32 | 233.19 | 316.11 | 432.08 | |||||||
total | 1264.39 | 3339.70 | 2862.54 | 1881.10 | 2420.13 | 2475.91 | 3231.41 | total | 1158.75 | 2683.66 | 2648.45 | 2920.76 | 5654.37 | 21806.60 |