[rt-users] RT 3.6.4 poor query performance

[Richard Ellis]

Hi Ruslan,

I have changed those indexes this morning and will monitor the results 
today. I created the second new index as CGM2 to prevent the system 
complaining about duplicate keys.

Thanks

Richard

Ruslan Zakirov wrote:
> 4 seconds is still slow, but better than 100-400.
>
> About your indexes. You can and I really suggest to delete the
> following indexes on CGM table:
> * DROP INDEX GrouMem ON CachedGroupMembers;
> * DROP INDEX group1 ON CachedGroupMembers;
> * DROP INDEX member1 ON CachedGroupMembers;
>
> And instead create indexes:
> CREATE INDEX CGM1 ON CachedGroupMembers(MemberId, GroupId, Disabled);
> CREATE INDEX CGM1 ON CachedGroupMembers(MemberId, ImmediateParentId);
>
> Both will be part of 3.8's schema update.
>
> On Wed, Mar 19, 2008 at 8:35 PM, Richard Ellis <Richard.Ellis at sun.com> wrote:
>   
>>  Hi Ruslan,
>>
>>  You are a genius. Response time for the Query Builder is now back to 4
>> seconds which is good enough for me :0.
>>
>>  Thanks to all your team for all the efforts to work out what was wrong.
>>
>>
>>  Thanks
>>
>>  Richard
>>
>>
>>  Ruslan Zakirov wrote:
>>
>>  Hey, Rechard, the latest results suggest me that we've saddled this
>> beast :) at least that what explain says and I hope it's correct.
>>
>> You can check that query again and it should be fast. Wanna try?
>>
>> You can use SELECT SQL_NO_CACHE ... to make sure it's reproducible and
>> is not cache hit.
>>
>>
>>
>> On Wed, Mar 19, 2008 at 7:22 PM, Richard Ellis <Richard.Ellis at sun.com>
>> wrote:
>>
>>
>>  Hi Ruslan,
>>
>>  here's the two sets of results.
>>
>>
>>  Thanks
>>
>>  Richard
>>
>>
>>
>>
>>     
>
>
>
>   

-- 
Sun.com <http://www.sun.com> 	* Richard Ellis *
Technical Developer, .Sun eBusiness

*Sun Microsystems, Inc.*
Phone x(70) 24727/+44-1252-424 727
Fax +44 1252 420410
Email richard.ellis at Sun.COM
	sun.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20080325/c135cac3/attachment.htm>