Jakob Hirsch wrote: > Hi everyone, > > I've searched a little through the archive but found not much about that. > Right now I'm using DBM for bayes. I know the officially recommended > storage is a SQL DB (though I don't know why). I have a mysql server > running on my mail system and tried using it for bayes a while ago (with > SA 3.1.0) but didn't see lower scan times. For a local RDBMS I think > SQLite is a very good thing, but there was a list post where somebody > said ist not suitable for SA (though README.bayes mentions it). > According to the bayes benchmark in the wiki > (http://wiki.apache.org/spamassassin/BayesBenchmarkResults), SDBM is the > fastest store (though there are no sqlite numbers), but I wonder why > it's not mentioned much. I'll probably run the bayes benchmark myself > (with sqlite, sdbm and dbm), but somebody has probably some experience > to share.
You're welcome to try SQLite, but all testing I did was too slow to even wait for results (multi-day runs vs multi-hour for other slow systems). The bayes storage module is such that you can modify the various queries to work better with whatever engine you would like (see Pg modifications). If a SQLite expert wants to take up the challenge and provide patches I'll happily review them for inclusion in the code. Michael
