[rt-devel] Slow Queries part3, Groups

[Robert Spier]

> 
> I'm guessing a index om Groups.Domain will improve things a bit (currently 
> importing, so I don't really want to generate an
> index at the moment, as it will lock the tables).
> 
> Anyone else getting this?


Do you already have these two indexes?

CREATE INDEX Groups1 ON Groups (Domain,Instance,Type,id);
CREATE INDEX Groups2 On Groups  (Type, Instance, Domain); 

The first one should be applicable to the query you pasted.

What version of MySQL are you using?

-R