[kdepim-users] rant

Pablo Sanchez pablo at blueoakdb.com
Wed Jan 28 13:44:10 GMT 2015

[ Comments below, in-line ]

On 01/28/2015 08:34 AM, Martin Steigerwald wrote:
> Am Mittwoch, 28. Januar 2015, 07:53:12 schrieb Pablo Sanchez:
> Hi Pablo,

Hi Martin,

>> As a Database and Performance engineer, I've investigated akonadi.
> Did you test this with Akonadi git
> c733429f4fa9696fb027ddc946e54f6bbb68deaf (branch 1.13)?
> It contains gems like:
> [ trimmed ]

Those were change Daniel rolled in based on my (incessant? :)

>> Daniel (sustaining engineer?) rolled in some changes to mitigate the
>> incessant queries.  I don't know which version of Akonadi has these
>> changes.
> Yes, see above :)


> And: It *does* help. I use it.

Yes, it should because making so many queries per second is ... well
... just not right.  :)

> But I also see the ideas for Akonadi Next as valid. While I know that
> using MySQL for handling the metadata of a ton of mails is possible as a
> groupware server like Zimbra shows by being able to access a folder with
> 480,000 mails (thats right!) in the Web gui withing 5-10 seconds,

A /single/ query returning 480,000 rows within 5-10 seconds is
absolutely doable.  :)

What killed Akonadi were the incessant number of individual queries.

> I think its possible to fix quite some of these implementation
> issues,

... I concur.

> And it caches too much, way too much. 75 GiB in file_db_data is just
> too much IMHO.

I think this growth has more to do with the nature of the database's
file extending while it performs /work/ but from the DB's perspective,
it's largely empty.  But I'm not 100% .... I'm starting to forget what
I discovered.  :) :) :)

> And it may even make sense to use something else than a SQL
> database.

Yes, I agree on this front too ... while a DB Engineer, I also realize
a DB is not suited for all tasks.

Take care!

ps:  I'm sorry for trimming a lot of your text ... I'm pretty much in
      agreement with nearly everything you wrote so I tried to keep the
      post trimmed.
Pablo Sanchez - Blueoak Database Engineering, Inc
Ph:    819.459.1926         Blog:  http://pablo-blog.blueoakdb.com
iNum:  883.5100.0990.1054

KDE PIM users mailing list
Subscription management: https://mail.kde.org/mailman/listinfo/kdepim-users

More information about the kdepim-users mailing list