Proko2 is Good News Towards Kolab2

Bo Thorsen bo at klaralvdalens-datakonsult.se
Wed Apr 14 10:54:39 CEST 2004


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

On Wednesday 14 April 2004 10:43, Jon Bendtsen wrote:
> Den 14. apr 2004, kl. 8:38, skrev 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-uk
> >>>>>uu 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 :-)
>
> What about searching across a particular user? Suppose you were looking
> for all
> communication with a client, customer, partner, ...

You still do this in the client. No need to bog down the server with it.

Bo.

- -- 

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

iD8DBQFAfPxPmT99lwfUS5IRAtLzAKDXtgDQPxlXtR52msJI/VWItY7LggCffgR3
VgsokWu+dq4oryVMyDv2NcM=
=hAK5
-----END PGP SIGNATURE-----




More information about the users mailing list