[Dovecot] Using MySQL to store email?

Grobian grobian at gentoo.org
Tue Jun 6 17:03:31 EEST 2006


On 06-06-2006 15:48:20 +0200, nodata wrote:
> Putting everything in a database would provide one benefit:
> * Less storage space needed due to duplicated e-mail

... assuming that the mails are completely identical (i.e. have no
slightly different headers) and that the database backend does expensive
duplicate elimination on its string heaps.

So the real benefit you get I think is:
* full text searching capabilities based on the IR-like indices
  provided/maintained by the database backend, such as for instance:
  http://dev.mysql.com/doc/refman/5.0/en/fulltext-query-expansion.html


-- 
Fabian Groffen
Gentoo for Mac OS X Project


More information about the dovecot mailing list