[rt-users] Upgraded Perl and apache/mod_perl and now a few things are really slow ...

[Ruslan Zakirov]

I think that I've fixed problem, could you test the attached patch against 1.46?

On 3/2/07, Philip Kime <pkime at shopzilla.com> 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.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: SB-1.46-dont_query_on_each_next_for_unions.patch
Type: text/x-patch
Size: 889 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20070304/16344dab/attachment.bin>