[Dovecot] Using MySQL to store email?
Udo Rader
udo.rader at bestsolution.at
Thu Jun 8 22:36:04 EEST 2006
On Thu, 2006-06-08 at 21:32 +0200, Jakob Curdes wrote:
> >And with great power comes great frustration: Instead of taking 50msec
> >to fetch a message, it takes 80msec, and instead of taking 25msec to
> >load a message into a mailbox, it now takes 200-500msec!
> >
> >
> I think the bottom line is that the original poster is very fond of
> MySQL - which is actually a great database, among others. But I fear he
> underestimates the load that a large mailserver would impose on any
> classical database system - many indexes would have to be regenerated
> all the time because with every incoming mail the fundamental data
> changes. I get his idea but fear that storing everything away to SQL is
> the wrong solution; we would end up putting large smtp proxies before
> the server in order to keep it running.
> This is a very different situation from a SQL driven http server where
> even in a shop system most data structures and their indexes remain
> constant most of the time. Another point is that it took the community
> years to produce a production-ripe version of a http server with DB
> backend. I think for the dovecot community this is not feasible at the
> moment. If there is a group of people willing to write a sort of plugin
> to support SQL, probably nobody here will object. But in the meantime I
> would like to see this list coming back to the more pressing thing of
> getting 1.0 out & running.
+1
thanks for saying this :-)
--
BestSolution.at EDV Systemhaus GmbH
http://www.bestsolution.at
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 191 bytes
Desc: This is a digitally signed message part
Url : http://dovecot.org/pipermail/dovecot/attachments/20060608/1e2172b9/attachment.pgp
More information about the dovecot
mailing list