[rt-users] Poor performance in upgrade from RT2 to RT3

[Ruslan U. Zakirov]

Jesse Vincent wrote:

>
>On Thu, Sep 18, 2003 at 01:24:02PM +0400, Ruslan U. Zakirov wrote:
>  
>
>>This request is one of major perfomance issues for me now.
>>Search by requestor email is slow under mySQL too, but if I add another 
>>email then mySQL hangs for ages.
>>    
>>
>
>Interesting.  The problem manifested there was something postgres
>specific. RT 3.0.5 was supposed to have largely fixed the perf issue
>with searching on multiple requestors. Can you capture one of the
>queries it generates and show us?
>
You are saying about wrong additional alias that was removed in 3.0.5?
If so then it's not an issue. Now I'm writing more corect bug report for 
this. Just one second.

>
>  
>
>>It's very offten when our workers do misstake in email and then without 
>>deleting condition add another one and mySQL try to do its job. This 
>>search locks user's session for long time(~15 hours, one of this 
>>requests has finished :-) ) 
>>    
>>
>
>Interesting. Session lockfiles are supposed to time out a good deal more
>quickly than that, I thought.
>
No. Timeout of 'select get_lock' is ok, but query is spinning and thus 
session is still locked.

>
>  
>
>>Same things happen with other search 
>>conditions when you add another one of same type and they joins on OR 
>>clause.
>>               Best regards. Ruslan.
>>
>>
>>    
>>
>
>  
>