[prev in list] [next in list] [prev in thread] [next in thread] 

List:       kroupware
Subject:    Re: Proko2 is Good News Towards Kolab2
From:       Ilja Booij <ilja () ic-s ! nl>
Date:       2004-04-14 8:20:57
Message-ID: 1081930857.3243.16.camel () test01 ! office ! fastxs ! net
[Download RAW message or body]

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


_______________________________________________
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]