projects / civicrm-core.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 5d95f29) | patch
CRM-19821 performance improvement on the activity search.
authoreileen <emcnaughton@wikimedia.org>
Fri, 28 Apr 2017 03:51:16 +0000 (15:51 +1200)
committereileen <emcnaughton@wikimedia.org>
Thu, 22 Jun 2017 04:26:56 +0000 (16:26 +1200)
commit7bd16b05a86ce9bee5214551febde80d43fc1cd3
tree6955ea2e55a456ba3eedc3e0bc6ec5edbba28199tree | snapshot (zip tar.gz)
parent5d95f297830e80bcaf7368c8cc8e45f6c9523e86commit | diff
CRM-19821 performance improvement on the activity search.

This commit removes 2 bad joins from the activity search
- priority_id - this is just removed from the returnProperties as it is not rendered
- activity_status_id - this is handled as a pseudoconstant rather than the bad join

activity_type_id is partially handled, however, there is a component_id filter
that needs to be fixed before the bad join on this
field can be removed.
CRM/Activity/BAO/Query.php diff | blob | blame | history
CRM/Activity/Selector/Search.php diff | blob | blame | history
CRM/Contact/BAO/Query.php diff | blob | blame | history
CRM/Core/DAO.php diff | blob | blame | history