Revision d59b46d...
Go back to digest for 2nd September 2012Optimization 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