diff options
author | mattab <matthieu.aubry@gmail.com> | 2014-12-05 15:53:27 +0300 |
---|---|---|
committer | mattab <matthieu.aubry@gmail.com> | 2014-12-05 15:53:27 +0300 |
commit | a37254a976502a342a863ece8b285b96faff9494 (patch) | |
tree | 2a90fbe405d772c9d0007e28e69a45ca26bc7440 /plugins/Live | |
parent | dac71ca1347dbde11618e99b2dfe589d3d1812b8 (diff) |
The ultimate prize and final step to close the issue: do not group by the whole set of matched rows, way too slow on huge datasets!
Diffstat (limited to 'plugins/Live')
-rw-r--r-- | plugins/Live/tests/System/ModelTest.php | 1 |
1 files changed, 0 insertions, 1 deletions
diff --git a/plugins/Live/tests/System/ModelTest.php b/plugins/Live/tests/System/ModelTest.php index 90196e7309..268a7861d4 100644 --- a/plugins/Live/tests/System/ModelTest.php +++ b/plugins/Live/tests/System/ModelTest.php @@ -91,7 +91,6 @@ class ModelTest extends SystemTestCase AND log_visit.visit_last_action_time >= ? AND log_visit.visit_last_action_time <= ? ) AND ( log_link_visit_action.custom_var_k1 = ? ) - GROUP BY log_visit.idvisit ORDER BY idsite, visit_last_action_time DESC LIMIT 100 ) AS log_inner |