[Kde-pim] Excessive amount of queries

[Milian Wolff]

On Monday 01 December 2014 12:50:36 Christian Mollekopf wrote:
> On Monday 01 December 2014 12.29:39 Milian Wolff wrote:
> > Hello all,
> > 
> > I know you are all thinking about Akonadi Next, but I'd love to see some
> > work on improving the Akonadi we have now, and will have for quite some
> > time.
> > 
> > When you enable the query debugger in akonadiconsole, you'll see that just
> > switching to a different email in KMail, will easily end up triggering
> > ~200
> > queries. Can someone with more knowledge tell me if really all of that is
> > required?
> 
> I doubt it but would have to look at the actual queries.

with this patch, it's trivial for you to check it: There is also a screenshot 
attached of some results for me.

https://git.reviewboard.kde.org/r/121307/


> > I'm in the process of improving the query debugger interface, to
> > aggregate information on queries. That should show us better which queries
> > are triggered repeatedly and take a long time.
> 
> One part that I improved in the kolab branches that did not yet make it
> upstream is refactoring LIST so it doesn't do recursive queries. This is
> where a single CollectionFetchJob can easily trigger N queries where N is
> the number of folders you have. So in case you stumble over that, be aware
> that this should be already solved somewhere (and that I will merge that
> upstream as well).

Yes, I think that is the main culprit. Can you please backport that to 1.13?

Bye
-- 
Milian Wolff
mail at milianw.de
http://milianw.de
_______________________________________________
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/