Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: converted to 1.6 markup

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.

...

  • 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 MyISAM

MySQL.pm
MySQL - MyISAM

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
InnoDB

PgSQL.pm
fsync=false

PgSQL.pm
fsync=true

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