[rt-users] performance question

[Jesse Vincent]

On Nov 29, 2006, at 6:34 AM, Filip Rembialkowski wrote:

> hi all RT users,
>
> at my work we have such setup:
>
> 135 queues
> 49000 tickets
>
> RT 3.4.1 running on
> Apache/1.3.33 (Debian GNU/Linux) mod_perl/1.29, Perl 5.8.4
>
> I was running a test for following scenario:
> . Connect to web interface
> . Login as root
> . Display one random queue
> . Search for one random ticket using the top search box
> . Logout
>
> After enabling query logging, I have observed that running above  
> scenario
> _once_ resulted in almost 1500 queries to my postgresql backend. so  
> this
> is 1500 queries for the scenario, which essentially consists of  
> displaying
> 3 pages:
>
> 1) home page with standard settings (queues visible on the right side,
>  top10 and unowned in the middle)
> 2) the page with one particular queue
> 3) the page with one particular ticket
>
> i have also enabled detailed query logging, and observed that about  
> 60% of
> database time is spent on queries which are used for ACL checking.
>
> so... my question is: is this normal?

That sounds surprisingly high. But you're also testing with  
an...older RT. And I know we've made some big performance  
improvements since then. I can't guarantee that we've fixed whatever  
you're running into, but coming up to 3.4.6 or 3.6 is strongly  
recommended.