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
signature.asc
Description: Digital signature
_______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [email protected] 2010 RT Training Sessions! San Francisco, CA, USA - Feb 22 & 23 Dublin, Ireland - Mar 15 & 16 Boston, MA, USA - April 5 & 6 Washington DC, USA - Oct 25 & 26 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
