Comment 9 for bug 1400524

Revision history for this message
Mahara Bot (dev-mahara) wrote : A change has been merged

Reviewed: https://reviews.mahara.org/4145
Committed: http://gitorious.org/mahara/mahara/commit/dc478caf2b219efd93b06a9bf0ed8c2d2fc40a92
Submitter: Son Nguyen (<email address hidden>)
Branch: 1.10_STABLE

commit dc478caf2b219efd93b06a9bf0ed8c2d2fc40a92
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: I46c13cc97bac8a6d2bc626e3b2dc8e4cdeecd2bb