[Dovecot] Using MySQL to store email?

[Les Mikesell]

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 at gmail.com