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

[Palle Girgensohn]

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
-------------- next part --------------
An embedded message was scrubbed...
From: Palle Girgensohn <girgen at pingpong.net>
Subject: [rt-devel] performance problems
Date: Thu, 15 Jan 2004 03:27:46 +0100
Size: 4923
Url: http://pallas.eruditorum.org/pipermail/rt-devel/attachments/20040226/a8f19d4f/attachment.mht