Proko2 is Good News Towards Kolab2

Jon Bendtsen jon at kollegiegaarden.dk
Wed Apr 14 10:43:38 CEST 2004


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

What about searching across a particular user? Suppose you were looking 
for all
communication with a client, customer, partner, ...


JonB




More information about the users mailing list