[rt-users] RT 3.6.4 poor query performance

[Richard Ellis]

Hi Ruslan,

here's the two sets of results.

Thanks

Richard


Ruslan Zakirov wrote:
> Ok, I have an idea how to fix that problem
>
> Here is new file for testing that will give me more info to find the
> best way to fixing this. We're really close.
>
> You can run it using:
> mysql -t -u root -ppassword rt3 <../search_possible_owners.mysql.sql >test.res
>
> As a first step to fix it you can create the following index on Groups table:
> CREATE INDEX RUZ_Groups1 ON Groups(Domain, Type, id);
>
> Please, run commands from the attachment twice before indexing and after.
>
> Thank you for the feedback.
>
> On Wed, Mar 19, 2008 at 11:49 AM, Richard Ellis <Richard.Ellis at sun.com> wrote:
>   
>>  Hi Ruslan,
>>
>>  Really appreciate the help on this. I'd love to find out why we are seeing
>> such odd results:
>>
>>  298 ticket owners when their are only 88 active users
>>  1.5 million rows of data when we only have 9983 ticks as of this morning.
>>
>>  Really odd
>>
>>  Thanks
>>
>>  Richard
>>
>>
>>     
>
> [snip]
>
>
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20080319/936387be/attachment.htm>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: test.res
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20080319/936387be/attachment.ksh>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: testafter.res
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20080319/936387be/attachment-0001.ksh>