Mahara

  1. Bug #872631
  2. Comment #2

Comment 2 for bug 872631

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

Reviewed: https://reviews.mahara.org/788
Committed: http://gitorious.org/mahara/mahara/commit/e825502db66d93ddcbd58123876e503c0c850ee0
Submitter: Francois Marier (<email address hidden>)
Branch: master

commit e825502db66d93ddcbd58123876e503c0c850ee0
Author: Richard Mansfield <email address hidden>
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 <email address hidden>