[rt-users] Certain RT operations painfully slow.

[Jesse Vincent]

Todd,

> >> Which causes this long running mysql query:
> >>
> >>    Time: 86
> >>    Info: SELECT main.* FROM CachedGroupMembers main   WHERE ((main.Via = '28522070')) AND ((main.id != '28522070'))
> >>
> >> Can anyone recommend an approach to fixing this problem?
> >
> > What does an EXPLAIN on that select tell you?
> 
> mysql> explain SELECT main.* FROM CachedGroupMembers main   WHERE ((main.Via = '28522070')) AND ((main.id != '28522070'))\G
>   select_type: SIMPLE
>         table: main
>          type: range
> possible_keys: PRIMARY
>           key: PRIMARY
>       key_len: 4
>           ref: NULL
>          rows: 20568305
>         Extra: Using where
> 1 row in set (0.02 sec)

What happens if you add an index on Via?

Jesse
--