[Dovecot] Using MySQL to store email?
Jakob Curdes
jc at info-systems.de
Thu Jun 8 22:32:49 EEST 2006
>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.
Yours,
Jakob Curdes
More information about the dovecot
mailing list