Akonadi dsaster

[Michael Mol]

On Friday, October 14, 2016 09:38:15 AM Daniel Vrátil wrote:
> 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 :-)

I'll have to see what I can do. I'm still on *checks* Kontact 4.14.10. I 
believe there's a KDE dev overlay already, so I may be able to just use that. 
I'll have to convert my home box to Gentoo to do the thing properly, though. 
That's going to be fun, and I'm not being sarcastic when I say that. :D

-- 
:wq
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 455 bytes
Desc: This is a digitally signed message part.
URL: <http://mail.kde.org/pipermail/kdepim-users/attachments/20161014/554401c6/attachment.sig>