[rt-devel] RE: [rt-users] RT3 performance on `reply' again

[Jesse Vincent]

Wow. Thanks for that report. I was starting to get very, very worried
about the incredibly varied reports about the new update. I'm going to
try to have a look at a little bit more optimization on that query. In
the meantime, are there indices that would clearly help this one?

	J


On Fri, Apr 18, 2003 at 11:56:07AM +0200, Paul Wagland wrote:
> Hi all,
> 
> > -----Original Message-----
> > From: rt-users-admin at lists.fsck.com
> > [mailto:rt-users-admin at lists.fsck.com]On Behalf Of Christian Zagrodnick
> >
> > I still have with this crasy query Jamie Wilkinson already noted in
> > http://lists.fsck.com/pipermail/rt-users/2003-April/013222.html
> >
> > I installed the latest SearchBuilder and it is still way slow.
> 
> We also have this issue, and we are running Postgres 7.2 and Debian.
> However, as a test, we tried a 7.3 database on another machine (which should
> be about 3 times faster PIII-800 vs PII-300) and the query went from about 4
> minutes to about 5 seconds... still extremely slow for what it is doing, but
> actually usable.
> 
> We will be re-running this test on the slow hardware after we update it, and
> will let you know of the results.
> 
> Cheers,
> Paul
> 
> 
> _______________________________________________
> rt-devel mailing list
> rt-devel at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-devel

-- 
http://www.bestpractical.com/rt  -- Trouble Ticketing. Free.