PukunuiAustralia/moodle-mod_certificate — pull request #9 by bunwich (2012-06-08 03:58:19+00:00)
Title: Optimized Certificate SQL Query 

Removed timecreated subquery.
Added Pagination.
Added two constants used for pagination.

Hi Pukunui,
We had a client who had 10K+ certificates in a course and it was taking over 5+ minutes to list certificates. These changes should now make the query take less than 4 seconds.

I also added pagination to the list all certificates page.

Test in Moodle 2.2.3+

Thanks,
bunwich