[Dbmail] How scalable is it?
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?
Re: [Dbmail] How scalable is it?
- complex usage reports and traffic details - postfix also uses DB, and again the virtuals are a view constructed based on other business rules. etc etc. In some sense, DBMail is the starting point for a much more usable and functional system of mail handling. You should not just focus on if it will be faster (although, making sure it won't be slower is important). What a great post. You should write a whitepaper!. I was thinking it might be possible to write triggers to manipulate the postfix text files but I did not know you could have postfix read the database directly that's great. Have you thought of using a non IMAP client for employees which taps into the database directly? I was thinking that might be good way to go internal employees and it would bypass whatever IMAP slowness there might be. :wq Tim Uckun US Investigations Services/Due Diligence http://www.diligence.com/