[Rt-devel] New index on groupmembers table

[Jesse Vincent]

On Jun 22, 2007, at 9:03 PM, Joby Walker wrote:

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

Thanks. I've created a ticket to investigate adding this for RT 3.8.

Best,
Jesse

> -- 
>
> Joby Walker
> C&C SSG, University of Washington
> _______________________________________________
> List info: http://lists.bestpractical.com/cgi-bin/mailman/listinfo/ 
> rt-devel
>

-------------- next part --------------
A non-text attachment was scrubbed...
Name: PGP.sig
Type: application/pgp-signature
Size: 186 bytes
Desc: This is a digitally signed message part
Url : http://lists.bestpractical.com/pipermail/rt-devel/attachments/20070703/aac1e5c6/PGP.pgp