Jesse Vincent wrote: > > On Wed, Mar 19, 2008 at 07:42:30PM +0300, Ruslan Zakirov wrote: > >> Jesse, I know that they both have index on CachedGroupMembers table >> that starts from 'MemberId' column. And it does mess up optimizer and >> doesn't matter if it's one column or multiple like in (MemberId, >> GroupId, Disabled) index (Jeff created such thing). We really need >> such index in the core on CGM table, otherwise people have problems >> with searches by watchers (like in "Requestor is XXX" search or "More >> about XXX" box). It's very sad that mysql can not deal with that. Fix >> I've implemented in 3.6.6 helps people on setups with few ACL records >> and few queues, but not in these two cases. >> > > Got it It's a rename of one of the suggested indices in http://search.cpan.org/~ruz/RTx-Shredder-0.07/lib/RTx/Shredder.pm (see the Notes section).
CREATE INDEX SHREDDER_CGM1 ON CachedGroupMembers(MemberId, GroupId, Disabled); Jeff _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com