[Rt-devel] New index on groupmembers table

[Joby Walker]

I've noticed some significant improvement by adding the following index:

CREATE INDEX groupmembers1 on groupmembers (groupid, memberid);

Currently the groupmembers table is not indexed (apart from the PK), and
there are several operations that make use of the groupmembers table and
not the cachedgroupmembers table.  For example (in the stock RT) on
*every* page load RT checks to see if the currentuser is Privileged.


-- 

Joby Walker
C&C SSG, University of Washington