...o several tables and using a VIEW with UNION to read them as one. (See Tim Hunt [https://moodle.org/mod/forum/discuss.php?d=243531#p1104165 explanation] on *[http://tjhunt.blogspot.ca/2013/05/performance-testing-moodle.html Tim Hunt's blog (May 2, 2013) on performance testing Moodle]

...n moodledata on a shared network drive. Use memcached instead. See Tim Hunt's article on http://tjhunt.blogspot.de/2013/05/performance-testing-moodle.h

* Tim Hunt - for his polite and useful answers and commentaries that helped writing th

...ctivity modules you may have in your site as you need. Also, thanks to Tim Hunt for improvements to this query. (Contributed by Juan F with help from Tim hunt and fellow Moodlers on the forums)