Revision d59b46d...

Go back to digest for 2nd September 2012

Optimization in KDE-PIM

Till Adam committed changes in [akonadi] server/src/handlerhelper.cpp:

Speed up statistics queries from O(n^2) behavior by avoiding a double inner join.

On Postgres 9.1 the query that uses two inner joins to limit the results
to collections with items with certain flags (like SEEN) is extremely
inefficient, for as yet unknown reasons. To work around this, we filter
manually by leveraging an in-memory cache of flag names to ids and using
those ids to filter.

Approved by vkrause.

File Changes

Modified 1 files
  • server/src/handlerhelper.cpp
1 files changed in total