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 filling in the paths
with an iterative series of UPDATE queries instead.
Reviewed: https:/ /reviews. mahara. org/4145 gitorious. org/mahara/ mahara/ commit/ dc478caf2b219ef d93b06a9bf0ed8c 2d2fc40a92
Committed: http://
Submitter: Son Nguyen (<email address hidden>)
Branch: 1.10_STABLE
commit dc478caf2b219ef d93b06a9bf0ed8c 2d2fc40a92
Author: Aaron Wells <email address hidden>
Date: Tue Dec 9 14:37:33 2014 +1300
Even quicker way to fill in artefact paths
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 filling in the paths
with an iterative series of UPDATE queries instead.
Change-Id: I46c13cc97bac8a 6d2bc626e3b2dc8 e4cdeecd2bb