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

Kevin Murphy murphy at genome.chop.edu
Wed Feb 25 20:29:54 EST 2004

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. 


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

More information about the Rt-devel mailing list