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

[Paul Wagland]

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