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

[Christian Zagrodnick]

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.

Actually this is a 7.3 on a Piii 1000.

-- 
Christian Zagrodnick

gocept gmbh & co. kg - schalaunische strasse 6 - 06366 koethen/anhalt
fon. +49 3496 3099112, +49 179 1463644
fax. +49 3496 3099118