Proko2 is Good News Towards Kolab2

Ilja Booij ilja at ic-s.nl
Wed Apr 14 10:20:57 CEST 2004


On Wed, 2004-04-14 at 08:38, Bo Thorsen wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> Cool :-)
> 
> Actually there was one thing that several people said was an SQL advantage 
> that I don't think we answered yet. So here goes:
> 
> A DB is indeed good at one single thing: Executing queries (or searches). 
> Now, if this was needed on the server, then there might be a reason to 
> store stuff in a DB. The reason this isn't the case is that all searches 
> are done by the client. So you never ever use the potential of a DB on 
> the server, since that really just need to feed the client all the parts. 
> Someone claimed indexing is faster in a DB - again true. But cyrus only 
> needs a single index - the IMAP UID - and this is the name of the file 
> that stores the mail. There is no DB that can come close to the speed of 
> "ls" when it comes to indexing :-)

These points are all really valid. I've been thinking more about why we
would want to use a database for email storage. and cannot think of
anymore reasons why we'd want to.. hmm :( . Maybe I'll think of
something (I'll do my best!). Thanks for clearing up the matter!

Ilja





More information about the users mailing list