[rt-devel] rt still runs the same SQL query hundreds of times for
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
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
> 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 =
> I really need to get RT working now. How can I help debugging?
More information about the Rt-devel