Turns out you might be able to do a nested SELECT to get around that second issue, see http://www.xaprb.com/blog/2006/06/23/how-to-select- from-an-update-target-in-mysql/
-- You received this bug notification because you are a member of Mahara Contributors, which is subscribed to Mahara. https://bugs.launchpad.net/bugs/817796 Title: Slow upgrades for profile icons & group quotas Status in Mahara ePortfolio: Incomplete Bug description: Three recent upgrades are very slow on large databases and are in need of a bit of a rewrite: - The upgrade to remove bad profileicon references from the user table - The upgrade to initialise group file quotas - The upgrade which moves existing profileicons into an 'images' folder. https://reviews.mahara.org/#change,528 To manage notifications about this bug go to: https://bugs.launchpad.net/mahara/+bug/817796/+subscriptions _______________________________________________ Mailing list: https://launchpad.net/~mahara-contributors Post to : [email protected] Unsubscribe : https://launchpad.net/~mahara-contributors More help : https://help.launchpad.net/ListHelp
