mahara-contributors team mailing list archive

[Mahara Bot <872631@xxxxxxxxxxxxxxxxxx>]

Reviewed:  https://reviews.mahara.org/788
Committed: http://gitorious.org/mahara/mahara/commit/e825502db66d93ddcbd58123876e503c0c850ee0
Submitter: Francois Marier (francois@xxxxxxxxxxxxxxx)
Branch:    master

commit e825502db66d93ddcbd58123876e503c0c850ee0
Author: Richard Mansfield <richard.mansfield@xxxxxxxxxxxxxxx>
Date:   Wed Oct 12 14:03:53 2011 +1300

    Join on artefact table when fetching group artefacts (bug #872631)
    
    The artefact_access_role subselect can return a lot of rows when
    artefact_access_role is joined to group_member without also going
    through artefact.
    
    Also, the artefact_access_role & artefact_access_usr checks are
    moved in to subselects in the where clause, because that appears
    to make the query run faster.
    
    Change-Id: Ibba16c8db59213fe4861262a950d628937f5ec13
    Signed-off-by: Richard Mansfield <richard.mansfield@xxxxxxxxxxxxxxx>

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

Title:
  Artefactchooser query is slow

Status in Mahara ePortfolio:
  Fix Committed

Bug description:
  The query to fetch publishable artefacts for a block in the
  artefactchooser pieform element is slow, especially when the logged in
  user is in a lot of groups.  This should be fixed because the query is
  run more frequently than it used to be (each time a textbox block is
  configured: see bug #736665).

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