commit 5362403f242a386830df33b8f95e36a386035dc4
Author: Richard Mansfield <email address hidden>
Date: Tue Nov 22 15:33:29 2011 +1300
Remove excess joins from latest pages query (bug #889547)
When a user has many views shared with them, the view_search query
may exceed mysql's max_join_size and cause an unrecoverable error on
a user's dashboard, among other places. Replacing a bunch of these
outer joins with subselects fixes the issue, and in a few tests on a
large postgres db, also improved performance.
Change-Id: Ic3b82518e4571807ceae4747ab086eb4a9baa5db
Signed-off-by: Richard Mansfield <email address hidden>
Reviewed: https:/ /reviews. mahara. org/877 gitorious. org/mahara/ mahara/ commit/ 5362403f242a386 830df33b8f95e36 a386035dc4
Committed: http://
Submitter: Francois Marier (<email address hidden>)
Branch: master
commit 5362403f242a386 830df33b8f95e36 a386035dc4
Author: Richard Mansfield <email address hidden>
Date: Tue Nov 22 15:33:29 2011 +1300
Remove excess joins from latest pages query (bug #889547)
When a user has many views shared with them, the view_search query
may exceed mysql's max_join_size and cause an unrecoverable error on
a user's dashboard, among other places. Replacing a bunch of these
outer joins with subselects fixes the issue, and in a few tests on a
large postgres db, also improved performance.
Change-Id: Ic3b82518e45718 07ceae4747ab086 eb4a9baa5db
Signed-off-by: Richard Mansfield <email address hidden>