Reviewed:  https://reviews.mahara.org/561
Committed: 
http://gitorious.org/mahara/mahara/commit/28599c24a22d6a5b09b972ecbd68793ce16dc7aa
Submitter: Hugh Davenport ([email protected])
Branch:    master

commit 28599c24a22d6a5b09b972ecbd68793ce16dc7aa
Author: Richard Mansfield <[email protected]>
Date:   Thu Aug 4 15:21:30 2011 +1200

    Read artefact table in chunks when rebuilding parent cache (bug #820727)
    
    The cron job to rebuild the artefact_parent_cache table uses all the
    available memory when the artefact table gets big, so it needs to read
    it in in smaller chunks.
    
    This version of the function ensures that all artefacts with the same
    owner are read in at the same time, which means all artefact parent
    relationships are available.
    
    See http://mahara.org/interaction/forum/topic.php?id=2467 and
    http://mahara.org/interaction/forum/topic.php?id=2645 for more
    details.
    
    Change-Id: I459a2d4a9637716809476c5547bdf1ab7e81f0d4
    Signed-off-by: Richard Mansfield <[email protected]>

-- 
You received this bug notification because you are a member of Mahara
Core, which is subscribed to Mahara.
https://bugs.launchpad.net/bugs/820727

Title:
  rebuild_artefact_parent_cache_complete running out of memory

Status in Mahara ePortfolio:
  Confirmed

Bug description:
  See the following thread:
  http://mahara.org/interaction/forum/topic.php?id=2645

  That rewrite held the memory limit problem at bay for a little while,
  but now with a bigger artefact table (~300000 rows) cron.php is
  running out of memory again.

  rebuild_artefact_parent_cache_complete() should be modified so it
  reads the artefact table a bit at a time, instead of all at once.

To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/820727/+subscriptions

_______________________________________________
Mailing list: https://launchpad.net/~mahara-core
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~mahara-core
More help   : https://help.launchpad.net/ListHelp

Reply via email to