mahara-contributors team mailing list archive

[Aaron Wells <1358092@xxxxxxxxxxxxxxxxxx>]

... so I've move it to 1.9_STABLE instead:
https://reviews.mahara.org/#/c/3654

The original bug reporter said that removing the nested subqueries from
that UPDATE statement improved performance from taking > 1 minute to < 1
second, which is a drastic enough improvement (with no front-end change)
that it'd be worth distributing on a stable release as a bug fix.

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it!
https://bugs.launchpad.net/bugs/1358092

Title:
  Improve SQL performance when deleting notifications

Status in Mahara ePortfolio:
  In Progress
Status in Mahara 1.10 series:
  In Progress
Status in Mahara 1.9 series:
  In Progress

Bug description:
  Martin from Catalyst EU pointed out to me that the performance of the
  code in account/activity/index.json.php could be improved by stripping
  an unnecessary subquery from it.

To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1358092/+subscriptions