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/4072 gitorious. org/mahara/ mahara/ commit/ 31a1931435e4cd1 e9489c1814a42e9 ae96c6490d
Committed: http://
Submitter: Aaron Wells (<email address hidden>)
Branch: master
commit 31a1931435e4cd1 e9489c1814a42e9 ae96c6490d
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