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

[Christian Zagrodnick]

I think this query is optimised enough for now. At least it takes less
than a second. 

I'll look for other queries during the week.


On Sun, May 04, 2003 at 08:48:50AM -0400, Jesse Vincent wrote:
> 
> 
> > > A number of folks wrote me to say that they saw dramatic speedups with
> > > the new searchbuilder. I would, of course, appreciate additional help
> > > tuning for postgres. I know there's been a suggested column type change
> > > in the ACL system for faster querying which I haven't had a chance to
> > > lookup, but more work by the folks who know postgres well would be
> > > appreciated.
> > 
> > Well yes, it dropped from `i-don't-know' to 8 minutes with this giant
> > query.  Creating two additional indexes dropped it further to about 1
> > minute -- which is still too slow.  Certainly I could rewrite some query
> > manually to get some speedups if it helps (i.e. if it is integratable
> > into RT or SearchBuilder).
> 
> Actually, I'd appreciate it if you could have a look at:
> 
> http://lists.fsck.com/pipermail/rt-devel/2003-April/003697.html
> 
> 
> I think we're currently around aidan's partially-optimized query. 
> Would you mind having a look and seeing if you can improve on his work?
> I'm happy to put in more effort to speed postgres up, if I can get more
> input about what will help.
> 
> 	-j
> 
> 
> > -- 
> > Christian Zagrodnick
> > 
> > gocept gmbh & co. kg - schalaunische strasse 6 - 06366 koethen/anhalt
> > fon. +49 3496 3099112, +49 179 1463644
> > fax. +49 3496 3099118
> > 
> > 
> 
> 
> 
> -- 
> http://www.bestpractical.com/rt  -- Trouble Ticketing. Free.
> 

-- 
Christian Zagrodnick

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


-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20030505/185576c2/attachment.sig>