Proko2 is Good News Towards Kolab2

[Bo Thorsen]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Friday 09 April 2004 15:59, Jon Bendtsen wrote:
> Den 9. apr 2004, kl. 14:14, skrev Marc Groot Koerkamp:
> > Jon Bendtsen said:
> >>> For more info about the backend storage of cyrus which IMHO is
> >>> better then
> >>> using a db backend you can take a look at:
> >>> http://www-uxsup.csx.cam.ac.uk/~fanf2/hermes/doc/talks/2004-02-ukuu
> >>>g/ paper.html#3.1.%20The%20Cyrus%20message%20store
> >>
> >> What about clustering and distribution of data to more than one
> >> server?
> >
> > Cyrus IMAP Aggregator. (akna cyrus murder)
> > http://asg.web.cmu.edu/cyrus/ag.html
>
> allright, i can not figure out any more advantages with a database
> backend, just drawbacks.

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 :-)

Bo.

- -- 

     Bo Thorsen                 |   Praestevejen 4
     Senior Software Engineer   |   5290 Marslev
     Klarälvdalens Datakonsult  |   Denmark
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)

iD8DBQFAfNx1mT99lwfUS5IRAh3dAKC0b2oRI6BJyf170ihB2frjNGDohACcDBem
oZAxkIa4bzIwQ9lqh2sBhJg=
=+6t3
-----END PGP SIGNATURE-----