Does anybody have any benchmarks or even subjective opinions on how
dbmail performs when dealing with large volumes of mail?
I am considering transfering all of our user's mail, including all their
folders of saved and archived mail to dbmail. This will come to around
40-50GB, which makes for quite a large messageblks table. I don't have
enough experience with mysql to know how it will deal with that.
Presumably the more mail that is in the system, the slower things will
get. I'm not sure this fits with the idea of a 'scalable' system. With
the system we are using at present (sendmail/procmail/uw-imap), the
volume of saved mail has no effect on performance, so long as individual
folders and mailboxes are kept to a reasonable size. I can see that
dbmail will require less dicipline from users and will cope better with
those who let their inbox grow to hundreds of megabytes, but is it going
to get slower and slower over time?