mahara-contributors team mailing list archive

[Mahara Bot <1400524@xxxxxxxxxxxxxxxxxx>]

Reviewed:  https://reviews.mahara.org/4070
Committed: http://gitorious.org/mahara/mahara/commit/2656482ac99a7e51ce4b2a5e4f23f6fb92425e36
Submitter: Son Nguyen (son.nguyen@xxxxxxxxxxxxxxx)
Branch:    1.10_STABLE

commit 2656482ac99a7e51ce4b2a5e4f23f6fb92425e36
Author: Aaron Wells <aaronw@xxxxxxxxxxxxxxx>
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: Iddcfea3161fbfe804ec808119fe771757e7cdd5e

-- 
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:
  In Progress
Status in Mahara 1.10 series:
  New

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