On Tue, Jan 18, 2011 at 1:13 PM, Jesse Vincent <[email protected]> wrote: > 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?
I'm considering that, but with 20 million+ rows it will take a non-trivial amount of time. > > Jesse > -- >
