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 --
