Hello, It usually means missing key on CachedGroupMembers table, you need an index on (MemberId, GroupId) columns. Order of columns is important.
On Mon, Mar 8, 2010 at 1:29 PM, David X. Glover <[email protected]> wrote: > We're running RT 3.6.5* on MySQL 5.0.51a, and the "More about <User>" box on > the ticket display page takes several seconds to load. > > I've seen other people with this problem on the list, but never a solution. > > Does anyone have any ideas about what this specific box is doing and why it's > so slow? > > Cheers. > > *Yes, we acknowledge that it's out of date and we do have plans to upgrade, > just not immediately. > -- > David X. Glover > Department of Physics > University of Oxford > http://www.physics.ox.ac.uk/ > > _______________________________________________ > 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 > -- Best regards, Ruslan. _______________________________________________ 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
