Re: Akonadi dsaster

Daniel Vrátil <[email protected]> Fri, 14 Oct 2016 09:38:15 +0200
Newsgroups	gmane.comp.kde.users.pim
Organization	KDE
Message-ID	<1622113.9EHM6ZVqAZ@mjollnir>
On Wednesday, October 12, 2016 11:58:58 AM CEST Michael Mol wrote:
> On Wednesday, October 12, 2016 11:51:58 AM Pablo Sanchez wrote:
> > [ Comments below, in-line ]
> > 
> > On Wed, 12 Oct 2016 17:21:01 +0200, Diederik De Haas wrote:
> > > [ trimmed ]
> > > 
> > > So to me the database is a good suspect to investigate if and how
> > > things can be improved there with a real possibility of achieving
> > > significant improvements. And I was hoping to trigger that
> > > discussion with my post ;-)
> > 
> > Hi,
> > 
> > I'm happy to help.  I'd like to return to KMail.
> > 
> > In order to help though, I'd first request a KMail KDE Dev (Dan?  :)
> > to work with me.
> > 
> > Once we find a dev, I can set up a VM to trace the DB side
> > of KMail and let them know what I see, try new methods, etc.
> > 
> > I could not spend eight hours per day though.  I could put up to an
> > hour or so a day (M-F).
> 
> I'd also be interested in helping. My time is much more constrained, though,
> even if I do bring a combination of coding, DB and sysadmin skills. I'd be
> able to put in one or two hours a week; not the greatest for latency. :)

Hey guys,

my time is also a bit limited nowadays, so any help is welcomed :)

We have a tool (Akonadi console) that gives a good overview of how many time 
each query is executed and avg/total cost of each. And I even have some pretty 
good idea where those endless queries are coming from. The trick is how to get 
rid of them :-).

We've already been through most of the expensive queries with Pablo previously 
and I think that, although not perfect, the queries are doing reasonably good 
and it's much more important now to focus on reducing the amount of queries we 
do. That however requires more actual programming work rather than DB work.

That said, I'm not discouraging you from contributing :) I can help you get 
Akonadi compiled from git and point you to our biggest hotspots, but just to 
warn you that in our case optimizing database use might have very little to do 
with actual databases :-)

Cheers,
Dan

-- 
Daniel Vrátil
www.dvratil.cz | [email protected]
IRC: dvratil on Freenode (#kde, #kontact, #akonadi, #fedora-kde)

GPG Key: 0x4D69557AECB13683
Fingerprint: 0ABD FA55 A4E6 BEA9 9A83 EA97 4D69 557A ECB1 3683
signature.asc (application/pgp-signature, 819 B)