[Kde-pim] Excessive amount of queries

[Christian Mollekopf]

On Monday 01 December 2014 13.39:50 Milian Wolff wrote:
> 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/
> 

Jup, that could very well be LIST with statistics and attributes.

> > > 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?
> 

I'll have to discuss with Daniel how we go about that.

Cheers,
Christian

_______________________________________________
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/