MDL-37250 mod_lesson: Move conditions to queries for better performance
authorEloy Lafuente (stronk7) <stronk7@moodle.org>
Tue, 12 Jul 2016 11:26:46 +0000 (13:26 +0200)
committerEloy Lafuente (stronk7) <stronk7@moodle.org>
Tue, 12 Jul 2016 11:31:25 +0000 (13:31 +0200)
commit9f4c5c542b6f817552b5cda49a4fdd2e78f6d4f9
tree223cdd9da548698926f577c20a36269e049078ce
parent9401ee156c9d68ac7becfc52412201a68baa6fef
MDL-37250 mod_lesson: Move conditions to queries for better performance

While this ony seems to affect MySQL, better put the filter/conditions
on every query so the temporary view/table does not need to handle
thousands of potentially unrelated records.
mod/lesson/report.php