Rt still runs the same SQL query hundreds of times for one request

RT Developers
1

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

[rt-devel] performance problems (4.77 KB)

2

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.

-KevinOn 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