[Kde-pim] Re: distro considering akonadi -DDATABASE_BACKEND=SQLITE

[Volker Krause]

On Wednesday 27 July 2011 14:28:30 İsmail Dönmez wrote:
> Hi Volker;
> 
> 2011/7/17 Volker Krause <vkrause at kde.org>
> 
> > On Wednesday 13 July 2011 20:00:43 Klaas Freitag wrote:
> > > Am Mittwoch, 13. Juli 2011, 14:32:48 schrieb İsmail Dönmez:
> > > > Hi;
> > > > 
> > > > On Wed, Jul 13, 2011 at 2:23 PM, Rex Dieter <rdieter at math.unl.edu>
> > 
> > wrote:
> > > > > With my fedora packager/maintainer hat on, we're seriously
> > 
> > considering
> > 
> > > > > building akonadi to use sqlite storage backend by default.  This is
> > > > > largely to enhance our livecd experience as well as be more friendly
> > 
> > for
> > 
> > > > > home-on-nfs
> > > > > setups.
> > > > > 
> > > > > Any comments or objections?
> > > > 
> > > > I'd say amen to that, mysql dependency is really bad for a desktop
> > > > program.
> > > > I wonder how is the relative performance , at least feeling wise. Any
> > > > words
> > > > on that?
> > > 
> > > I know from another project (Kraft)  where sqlite is really slower than
> > > mysql. But that might be different for akonadi, I don't know.
> > 
> > Yes, Sqlite is slower (~2-5x on the query level last time we measured),
> > but
> > still somewhere in the milliseconds range, so that's not such a big issue.
> > The
> > real problem is the lack of real concurrency support in Sqlite, which
> > requires
> > a very crude transaction serialization in Akonadi that can block clients
> > while
> > another one is accessing the data. This is one of the main issues Akonadi
> > tries to solve compared to KMail 1, and the main reason we do not
> > recommend
> > Sqlite as the default.
> > 
> > See also http://techbase.kde.org/Projects/PIM/Akonadi/Database .
> 
> This page mentions some patches for QtSQL module, do you have any links for
> that?

Not directly, but it's all in the Akonadi Git repository. We effectively have 
a fork of the QtSql Sqlite driver there, which is shipped and installed 
together with Akonadi. Something we should eventually upstream of course...

regards
Volker
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 190 bytes
Desc: This is a digitally signed message part.
URL: <http://mail.kde.org/pipermail/kde-pim/attachments/20110731/4adec6dd/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/