[rt-users] RT 3.6.4 poor query performance

[Richard Ellis]

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
>>
>>     
>
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20080319/a8b9298b/attachment.htm>