[rt-users] "More about" box loads very slowly

[Dominic Hargreaves]

On Mon, Mar 08, 2010 at 04:32:21PM +0300, Ruslan Zakirov wrote:

> Create primary key on Users(id). Drop index Users3. As an option make
> keys Users2 and Users4 unique.

> Create index on CachedGroupMembers(MemberId, GroupId, Disabled) and
> reversed one CachedGroupMembers(GroupId, MemberId, Disabled).

It might be useful to add this information to the wiki here:

http://wiki.bestpractical.com/view/DatabaseIndexes

Cheers,
Dominic.

-- 
Dominic Hargreaves, Systems Development and Support Team
Computing Services, University of Oxford
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 197 bytes
Desc: Digital signature
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20100308/313a0ee8/attachment.sig>