diff options
author | Thomas Steur <tsteur@users.noreply.github.com> | 2018-05-19 04:21:37 +0300 |
---|---|---|
committer | diosmosis <diosmosis@users.noreply.github.com> | 2018-05-19 04:21:37 +0300 |
commit | 34191a72b84bde53f7fb58a04d62be8bac09d4fa (patch) | |
tree | cbbcd362619a3c65dfc8ddc98113c1db11b80bd4 /plugins/Events | |
parent | 7f3e0c7d7e0cdb73c8ae2e3862c147aac1e63c39 (diff) |
Improve memory usage for some action archivers (#12930)
* Improve memory performance of event queries
* also improve memory of action archive queries
* improve memory usage for content tracking
* fix typo
Diffstat (limited to 'plugins/Events')
-rw-r--r-- | plugins/Events/Archiver.php | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/plugins/Events/Archiver.php b/plugins/Events/Archiver.php index 76e4c3e677..69531a5c81 100644 --- a/plugins/Events/Archiver.php +++ b/plugins/Events/Archiver.php @@ -172,9 +172,9 @@ class Archiver extends \Piwik\Plugin\Archiver AND log_link_visit_action.idsite = ? AND log_link_visit_action.idaction_event_category IS NOT NULL"; - $groupBy = "log_action_event_category.idaction, - log_action_event_action.idaction, - log_action_event_name.idaction"; + $groupBy = "log_link_visit_action.idaction_event_category, + log_link_visit_action.idaction_event_action, + log_link_visit_action.idaction_name"; $orderBy = "`" . Metrics::INDEX_NB_VISITS . "` DESC"; |