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

[Ruslan Zakirov]

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
<d.glover1 at physics.ox.ac.uk> 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: sales at bestpractical.com
>
> 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.