On Tue, 2006-06-06 at 16:40 -0700, Marc Perkel wrote:
I'm suggesting it in addition to MBOX and MAILDIR. And of course if there's a MySQL version then other databases will follow. Just seems to me that if I were running a really BIG email operation that MySQL could have some serious benefits.
Using a "big ol' SQL database" will ALWAYS give _worse performance_ than a specialized solution (like dbox), and will usually give _worse performance_ than a naive but still specialized solution (like maildir or mbox).
Not true for "always". If you have 100,000 messages in a folder the database will win easy.
On what operations? Suppose you want to delete a message out of the middle and release the file space back to the OS? That's pretty quick in a filesystem like Reiserfs.
-- Les Mikesell lesmikesell@gmail.com