Hello, I work in the information security department of a large corporation. Our mail server admins currently deliver to us all mail that passes through exchange to an E-mail account, which we then put into a custom MySQL table by way of a PHP script. This is very slow, but we have written custom applications to examine attachments etc for pornography (to be referred to HR) and to prevent leaks of competitive information and although slow there are few users (only four of us) so we live with it. After we found your project we were interested in migrating to it. Do you think DBMail would be a good fit for such a situation? Our table currently stores date, from, to, cc, subject, body, and generic has_attachment,has_image, and has_officefile flags. The body field is fulltext indexed. We keep attachments in flatfiles on disk. We presume your solution would be a little faster. :-)
If anyone has any experience using DBMail for such a project (we average 150,000-200,000 messages a day), let me know. Thanks!
