[EMAIL PROTECTED] wrote:
Linda A. Walsh wrote:
6.86 msgs/sec? Wazup? Used to take about a tenth of that time,
though
it did jump up in 3.0x over 2.6x. But 7 msgs/second? That seems
abysmally slow compared to previous runtimes. Might as well be
running on a 286. (2x1GHz P-III's w/1GB, 15K-RPM SCSI system disk, a
bit old, but not _that_ old...).
Are you using BerkeleyDB-based Bayes databases? If those have gotten huge,
that could explain the slowdown.
----
Um...A BRKLY-B-BY-DB? Hmmm...maybe...I ran the default conversion from
the 2.x series to convert to the 3.x series -- did that default to
Bazerkely?
My DB has only been around for 2 years or so, this slow down was
"overnight" --
i.e. -- when I installed 3.10...um...AH HA! One problem tracked down --
it's
back to about pre-3.10 speed...there were 3
bayes.lock.mycomputer.domain.<pid>
laying around in my .spamassassin directory....removing those increased
the speed
up to ~36 msg/s which is about what I saw in 3.04 (still slower than 2.x
speeds,
but price of increased flexibility (features/intelligence) is often speed,
especially in single threaded apps.
Perhaps a SQL-daemon-based Bayes database is worth considering?
Do you know off hand if there is a there is a 'HOWTO' or FAQ
on converting from the default DB to an SQL-daemon-based DB --
consider I virtually know nothing about SQL & databases other than
my minimalist perception that they store data and allow one to
perform specific types of queries on the data, at speeds comparable
to searching through an ordered list, but multiple fields in
the DB appear to be "indexed".
I also have the option of rebuilding the DB. I do have some
number of archived "junk" mboxes (growing daily! ;>) ).
I haven't tried a separate SQL deamon -- but that could be "fun"
(assuming I am not overwhelmed for time, which is usually,
but that's besides the point, I need some fun now and then...
*urk*; me and my demented notions of 'fun'...:-)
thanks!
Linda
