[rt-users] 100's of duplicate database queries? postgresql

[Marco A P D´Andrade]

I found a similar problem, but I have about 3000 tickets, and 31 users 
and a relative complex acl. My response time is about 6 and 10 seconds.
During debug querys I count about 40 times (cut ... | sort | uniq -c ), 
but wait for have time to debug code.

I don't have time to finish this work, but supose problems around on 
sucessive query's on isa tree
Queue/Ticket -> ACE -> EasySearch -> ACL -> CurrentUser -> User -> 
_HasRight...

If have time to verify, debug the hashkey and expire (10 seconds) on 
Users.pm.

PS: I don't finish this debug, but now my new project use 
DBIx::SearchBuilder ( Thank's Jesse ! It's a great work ! )

Marco Antonio



seph wrote:

>how many users do you have in the system?
>how many watchers on the ticket? you're initial mail didn't say.
>
>seph
>
>Tarragon Allen <tarragon at onthe.net.au> writes:
>
>  
>
>>On Tuesday 07 January 2003 15:16, seph wrote:
>>    
>>
>>>Tarragon Allen <tarragon at onthe.net.au> writes:
>>>      
>>>
>>>>Hi,
>>>>
>>>>I'm presently trying to determine why our version of RT is running so
>>>>slow. At first we thought it was because the system it was running on was
>>>>underpowered, however I've just moved it across to a new high powered
>>>>machine and it's still running dog slow.
>>>>        
>>>>
>>>did you look in the mail archives? Or the faq? they both have some
>>>suggestions.
>>>      
>>>
>>Yes, and yes. As I said, I've looked at the indexes, they appear fine, and 
>>yes, I've looked at the hardware running the show, however it seems to me 
>>that for the size of our database, compared to other discussions where RT is 
>>running slow, we should not be seeing these sorts of slowdowns.
>>
>>It seemed strange to me that RT is making 100's of apparently duplicate 
>>queries for a single "view ticket". Is this normal behaviour, and if so, 
>>wouldn't it be a lot more efficient to do one query and cache it?
>>
>>I came to this list as a last resort after spending quite a lot of time trying 
>>to determine what was wrong myself.
>>
>>t
>>-- 
>>GPG: http://n12turbo.com/tarragon/public.key
>>    
>>
>_______________________________________________
>rt-users mailing list
>rt-users at lists.fsck.com
>http://lists.fsck.com/mailman/listinfo/rt-users
>
>Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm
>
>
>  
>