Mahara

  1. Bug #889547
  2. Comment #4

Comment 4 for bug 889547

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

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

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>