Also, Vivek Khera post alternative INDEXes set to the list several
times. He knows Pg better than I. I believe it could help you too.
Vivek, have you seen difference on Pg between 3.4.4 and 3.4.5? We'd
split a weird SQL query into two, the query is related to ACL checks.
On 11/14/06, Roy El-Hames <[EMAIL PROTECTED]> wrote:
Don;
Have you tried Ruslan'z suggestion to you:
1. Update DBIx::SearchBuilder module to the latest available on the CPAN.
2. upgrade RT to 3.4.5 at least as this version has several changes
that improve performance, one is major enough to do an upgrade
Also you can write you own debug statements, similar to:
$RT::Logger->debug("Whatever text you want here");
I would suggest adding 2 or 3 of those in Display.html at the start of
the <%INIT>
$RT::Logger->debug("Start processing Display.html");
In the middle near just above
} else {
if (!$TicketObj) {
and then at the bottom just before
</%INIT>
Restart Apache and then tail -f var/log/rt.log, and then try to browse a
ticket ..
Good luck
Roy
--
Best regards, Ruslan.
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
