[rt-users] RT 3.6.4 poor query performance

[Ruslan Zakirov]

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



-- 
Best regards, Ruslan.