[rt-users] Re: [rt-devel] DBIx-SearchBuilder 0.81 released

[Paul Wagland]

> > I never saw anyone respond to my emails on the subject where there was
> > called for testing with pgsql and your newer DBIx::SearchBuilder.  In
> > those emails I said that performance hadn't changed very much to make
> > it
> > worthwhile.
> >
> > So I wonder what changed which makes you say the above?
>
> Truth to tell, on my Pg box, I didn't notice much improvement in
> performance, either. :-(

Well, I was one of the people that noticed a massive improvment in execution
speed... Sadly it that gain appears to of have been all environment.

We moved from a PII/300 to a pIII/800 and our query times dropped from
roughly 15 minutes to around 5 seconds. At the same time, we also moved to a
new searchbuilder and from Postgres 7.2 to pg 7.3. Since I _know_ that a
pIII/800 is not 1500 times as fast as a pII/300 I assumed that it was one of
the softwares that caused the improvement.  We then spent some time fully
upgrading our RT3 machine, only to discover that the query was taking around
8 minutes on that box.

At that point, we just got a new machine, and now we can use RT fairly
happily. We only have a small number of users, and it is so much faster than
before that everyone thinks that it is fast :-) We also did some work with
hand optimising queries early on, and know that they can be much faster as
well....

Cheers,
Paul