Comment 5 for bug 1039865

We had the same issue after upgrade. We created an index artefact_access_role, create index arteaccerole_roleart_ix on artefact_access_role (role,artefact);

Even after the above index it is slow but better than before as now it takes few seconds 20-30.

https://mahara.org/interaction/forum/topic.php?id=5370&offset=0&limit=10#post23195