[Kde-pim] Akonadi datamodel questions

[Volker Krause]

On Thursday 24 May 2007 11:42:20 Robert Zwerus wrote:
> On Thursday 24 May 2007, Volker Krause wrote:
> > > Maybe a maildir-like system, where each item would have its own file in
> > > the filesystem. It would involve a lot of work creating it, but since a
> > > lot of mail servers use it, it might have advantages ;-).
> >
> > Right, this is a very important case for the actual content data. But
> > while the content data is certainly the largest part, it's only one out
> > out of many different fields we currently store in the database, most of
> > which we don't want to store directly in the filesystem I guess.
> >
> > So, what we might want to do is: Full abstraction for storing the actual
> > content data and QSQL-level abstraction for everything else. This would
> > be a compromise between flexibility and the amount of work needed.
>
> True. However, I'm not completely sure how the existing mail servers do it.
> I suppose they create index files for all the different fields in order to
> speed everything up.

Yes, that seems to be what Cyrus does. AFAIK it has a bdb index file per 
folder.

> Whether these indexes are stored in small index-files on the filesystem or
> in an SQL database doesn't make much of a difference, so your proposal
> sounds okay to me.

Well, I don't think we want per folder indices since the concept of a 
(physical) folder is getting less important with tags, virtual/search 
folders, etc.. Per folder indices might actually be a performance 
disadvantage in these cases.

regards
Volker
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part.
URL: <http://mail.kde.org/pipermail/kde-pim/attachments/20070525/c4e55216/attachment.sig>
-------------- next part --------------
_______________________________________________
kde-pim mailing list
kde-pim at kde.org
https://mail.kde.org/mailman/listinfo/kde-pim
kde-pim home page at http://pim.kde.org/