[Dovecot] Using MySQL to store email?
Marc Perkel
marc at perkel.com
Wed Jun 7 02:40:27 EEST 2006
Geo Carncross wrote:
> On Tue, 2006-06-06 at 08:25 -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.
> SQL's strengths are mutability, not performance- regardless of what you
> or others might think. USUALLY the database performance is "good enough"
> for most applications- but that doesn't mean it's even remotely close to
> optimal.
>
If you have a large system then what you might want is power and if you
want speed you just spend more money for faster hardware.
> Nevertheless, DBMail exists- it's an SQL backed IMAP server, and its
> active- and supports MySQL (in addition to SQLite and PostgreSQL).
>
I'd like to see Dovecot have that option as well.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://dovecot.org/pipermail/dovecot/attachments/20060606/182ee2f3/attachment.htm
More information about the dovecot
mailing list