[rt-users] RT 3.6.4 poor query performance

[Ruslan Zakirov]

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]


-- 
Best regards, Ruslan.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: search_possible_owners.mysql.sql
Type: application/octet-stream
Size: 2701 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20080319/b0fa4e0f/attachment.obj>