[rt-devel] rt still runs the same SQL query hundreds of times for one request

[Kevin Murphy]

I sent in a report of why this happens (and a fix), but I regret to inform you 
that the patch doesn't help significantly (at least with postgresql and our 
configuration, which is mod_perl 1).   We have a dual-1.4 GHz PPC OS X 
machine with 1.5 GB RAM running RT, and RT is not exactly a speed demon, but 
it is (barely) acceptable for our purposes.   I think the redundant queries 
may be a red herring for your performance problems, i.e. something else is 
the bottleneck. 

-Kevin

On Wednesday 25 February 2004 08:00 pm, Palle Girgensohn wrote:
> and this really makes rt unusable for us.
>
> See my thread here on "performance problems" from jan 15 2004. The problem
> persists, and RT is not usable. Any ideas on how I can help debugging this?
> Can it be the database being corrupt in some way? I've imported it from
> gnats.
>
> rt-3.0.9, searchbuild 0.97, freebsd 4.9, perl 5.8.2, fastcgi.
>
> The query beeing repeated looks like this:
> SELECT  * FROM Principals WHERE PrincipalType ILIKE 'User' AND ObjectId =
> '22'
>
> I really need to get RT working now. How can I help debugging?
>
> Regards,
> Palle