Artefactchooser query is slow
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
| Mahara |
Low
|
Richard Mansfield |
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).
Changed in mahara: | |
status: | New → In Progress |
importance: | Undecided → Low |
assignee: | nobody → Richard Mansfield (richard-mansfield) |
Changed in mahara: | |
milestone: | none → 1.5.0 |
status: | In Progress → Fix Committed |
Mahara Bot (dev-mahara) wrote : | #2 |
Reviewed: https:/
Committed: http://
Submitter: Francois Marier (<email address hidden>)
Branch: master
commit e825502db66d93d
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_
artefact_
through artefact.
Also, the artefact_
moved in to subselects in the where clause, because that appears
to make the query run faster.
Change-Id: Ibba16c8db59213
Signed-off-by: Richard Mansfield <email address hidden>
Melissa Draper (melissa) wrote : | #3 |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
status fixreleased
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://
iQEcBAEBAgAGBQJ
wyQwhMOm1wS5eB4
o7DlmKBJhXo7i/
XXI47L8e304a6Aw
YNmS3iU2+
UOVYo510SEKrkMC
=uHSn
-----END PGP SIGNATURE-----
Changed in mahara: | |
status: | Fix Committed → Fix Released |
Reviewed: https:/ /reviews. mahara. org/787 gitorious. org/mahara/ mahara/ commit/ b49a1353cafdb63 5bac19fedfa88de 63b5911dbb
Committed: http://
Submitter: Francois Marier (<email address hidden>)
Branch: master
commit b49a1353cafdb63 5bac19fedfa88de 63b5911dbb
Author: Richard Mansfield <email address hidden>
Date: Tue Oct 11 13:49:30 2011 +1300
Move admin public folder check into join condition (bug #872631)
This seems to speed the query up, probably because there are usually
not many files inside the admin public folder.
Change-Id: I99a3eff6e4b52e 4942f490331d6f2 cc48a3a5b0d
Signed-off-by: Richard Mansfield <email address hidden>