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.
... 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.