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,
>> 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
> 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
... 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
Yes, I agree on this front too ... while a DB Engineer, I also realize
a DB is not suited for all tasks.
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
Pablo Sanchez - Blueoak Database Engineering, Inc
Ph: 819.459.1926 Blog: http://pablo-blog.blueoakdb.com
KDE PIM users mailing list
Subscription management: https://mail.kde.org/mailman/listinfo/kdepim-users
More information about the kdepim-users