Reviewed: https://reviews.mahara.org/788 Committed: http://gitorious.org/mahara/mahara/commit/e825502db66d93ddcbd58123876e503c0c850ee0 Submitter: Francois Marier ([email protected]) Branch: master
commit e825502db66d93ddcbd58123876e503c0c850ee0 Author: Richard Mansfield <[email protected]> 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 protected]> -- You received this bug notification because you are a member of Mahara Core, 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 _______________________________________________ Mailing list: https://launchpad.net/~mahara-core Post to : [email protected] Unsubscribe : https://launchpad.net/~mahara-core More help : https://help.launchpad.net/ListHelp
