[rt-devel] Slow Queries part3, Groups

Matthew Watson mwatson at netspace.net.au
Wed Oct 8 01:41:53 EDT 2003


Yep, i've got those indexes,

Server version:         4.0.15a-standard-log

Regards
Matt Watson.



--On Tuesday, October 07, 2003 10:31 PM -0700 Robert Spier 
<rspier at pobox.com> wrote:

>>
>> 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
> _______________________________________________
> rt-devel mailing list
> rt-devel at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-devel







More information about the Rt-devel mailing list