[prev in list] [next in list] [prev in thread] [next in thread]
List: kroupware
Subject: Re: Proko2 is Good News Towards Kolab2
From: Bo Thorsen <bo () klaralvdalens-datakonsult ! se>
Date: 2004-04-14 6:38:44
Message-ID: 200404140838.46230.bo () klaralvdalens-datakonsult ! se
[Download RAW message or body]
-----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-----
_______________________________________________
Kolab-users mailing list
Kolab-users@kolab.org
https://kolab.org/mailman/listinfo/kolab-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic