For the moment, this is just a dump of some benchmark 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.
...
Here is a test run, with 2000 msgs per bucket (1000 in the forget buckets).
System is SUSE Linux 9.2, 2.8 P4 (HyperThread) 512MB RAM w/ Perl v5.8.5
- Berkeley DB - 4.3.x
- MySQL - 45.10.710
- PostgreSQL - 78.4.50.3 (with pg_autovacuum running every 60 seconds)
Everything ran local to the box
- Run using Mail-SpamAssassin 3.1.0-RC1 release
- PostgreSQL not available since I need to run them against the new code
- SDBM numbers are from an experimental patch to SA that will hopefully be available in trunk soon
Phase | SDBM.pm | DBM | Berkeley DBM | (Berkeley DB/DB_File) | SQL.pm | MySQL.pm | MySQL - InnoDB | PostgreSQL |
1a | 82.88 | 120.10 | 399.55 | 422.53 | Not Done Yet | |||
1b | 65.83 | 98.41 | 261.20 | 293.93 |
| |||
|
|
|
|
|
| |||
2 | 497.33 | 1151.58 | 743.53 | 781.65 |
| |||
|
|
|
|
|
| |||
3 | 14.03 | 40.03 | 9.23 | 6.22 |
| |||
|
|
|
|
|
| |||
4a | 35.25 | 65.06 | 288.81 | 363.93 |
| |||
4b | 28.27 | 46.61 | 241.51 | 308.21 |
| |||
|
|
|
|
|
| |||
5a | 261.14 | 803.19 | 481.69 | 517.51 |
| |||
5b | 174.01 | 358.67 | 222.93 | 232.02 |
|
...
.pm | PgSQL.pm | PgSQL.pm | |||||
1a | 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 |