Performance improvements for the code that fills in artefact.path
Bug 1400524: On a large site, the database queries to retrieve
all records from the artefact table can take too long to execute
and cause the PHP script to time out.
This optimization attempts to fix that by separately handling
the simpler case of parentless artefacts, and by removing
a redundant "select * from artefact"
Reviewed: https:/ /reviews. mahara. org/4069 gitorious. org/mahara/ mahara/ commit/ 3fc71a298c400a2 e760255b7ac7b74 f8e0042444
Committed: http://
Submitter: Son Nguyen (<email address hidden>)
Branch: master
commit 3fc71a298c400a2 e760255b7ac7b74 f8e0042444
Author: Aaron Wells <email address hidden>
Date: Tue Dec 9 14:37:33 2014 +1300
Performance improvements for the code that fills in artefact.path
Bug 1400524: On a large site, the database queries to retrieve
all records from the artefact table can take too long to execute
and cause the PHP script to time out.
This optimization attempts to fix that by separately handling
the simpler case of parentless artefacts, and by removing
a redundant "select * from artefact"
Change-Id: Iddcfea3161fbfe 804ec808119fe77 1757e7cdd5e