Reviewed: https://reviews.mahara.org/4072 Committed: http://gitorious.org/mahara/mahara/commit/31a1931435e4cd1e9489c1814a42e9ae96c6490d Submitter: Aaron Wells ([email protected]) Branch: master
commit 31a1931435e4cd1e9489c1814a42e9ae96c6490d Author: Aaron Wells <[email protected]> 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 -- You received this bug notification because you are a member of Mahara Contributors, which is subscribed to Mahara. Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it! https://bugs.launchpad.net/bugs/1400524 Title: Upgrading from 1.7 to 1.10 failed in big databases Status in Mahara ePortfolio: Fix Committed Status in Mahara 1.10 series: Fix Committed Bug description: Version: 1.10, and master(15.04) Platform: apache, postgres In big database, the upgrading has been failed when updating artefact table htdocs/lib/db/upgrade.php: 3255-3284 This process should be done in chunks as the the table 'artefact' may be big which will causes exceed execution time. See also: Bug #1298646 To manage notifications about this bug go to: https://bugs.launchpad.net/mahara/+bug/1400524/+subscriptions _______________________________________________ Mailing list: https://launchpad.net/~mahara-contributors Post to : [email protected] Unsubscribe : https://launchpad.net/~mahara-contributors More help : https://help.launchpad.net/ListHelp
