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

[Christian Zagrodnick]

Ah.. creating indexes. Yes.

create index groups3 on groups(domain);
create index groups4 on groups(instance);

Now i have 50 seconds. Still to slow but at least I get the reply page.
:)


On Fri, Apr 18, 2003 at 06:10:07AM -0400, Jesse Vincent wrote:
> 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.
> _______________________________________________
> rt-devel mailing list
> rt-devel at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-devel
> 

-- 
Christian Zagrodnick

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