I think that I've fixed problem, could you test the attached patch against 1.46?
On 3/2/07, Philip Kime <[EMAIL PROTECTED]> wrote:
Found the culprit - DBIx::Searchbuilder 1.46. I downgraded to 1.45_02
and it's now fine.
I have attached the query log of trying to open the Query Builder page
with 1.46. All that repeated
OR Principals_1.Disabled = '0'
Looks a little odd ...
PK
On Thu, Mar 01, 2007 at 05:18:35PM -0800, Philip Kime wrote:
> RT 3.6.3.
>
> I upgraded a server running apache/mod_perl to the latest stable
> versions, re-compiling them on a 64-bit RHEL4 box. I used the worker
> module for apache. I also re-compiled a 64-bit perl. Previously, the
> box was using 32-bit everything. Anyway, with the new setup, it all
> works except I get really slow repsonse times for loading the
> query-builder and the Reply page for tickets - about 90 seconds each.
> This makes me think it's related to the Owner drop-down. However, if I
> stop apache, put back the original Perl and original apache, both of
> those pages are fine and fast. So, it doesn't seem to be a DB problem?
>
[snip]
--
Best regards, Ruslan.
----------------------------------------------------------------------
r13998: cubic | 2007-03-04 02:54:14 +0300
* do the search only if we must do it
----------------------------------------------------------------------
=== DBIx-SearchBuilder/local/SearchBuilder/Union.pm
==================================================================
--- DBIx-SearchBuilder/local/SearchBuilder/Union.pm (revision 13997)
+++ DBIx-SearchBuilder/local/SearchBuilder/Union.pm (revision 13998)
@@ -108,7 +108,8 @@
return undef unless defined $self->{data}[ $self->{curp} ];
my $cur = $self->{data}[ $self->{curp} ];
- $cur->_DoSearch(); # force the search, instead of doing a count.
+ # do the search to avoid the count query and the search
+ $cur->_DoSearch if $cur->{'must_redo_search'};
if ( $cur->_ItemsCounter == $cur->Count ) {
# move to the next element
$self->{curp}++;
_______________________________________________
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
