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

[Christian Zagrodnick]

On Sun, May 04, 2003 at 01:49:00AM -0400, Jesse Vincent wrote:
> [Again, this doesn't need to be cross-posted to both rt-devel and
> rt-users]
> 
> On Sat, May 03, 2003 at 07:47:18AM -0500, David Wheeler wrote:
> > On Saturday, May 3, 2003, at 07:41  AM, Jeroen Ruigrok/asmodai wrote:
> > 
> > >I never saw anyone respond to my emails on the subject where there was
> > >called for testing with pgsql and your newer DBIx::SearchBuilder.  In
> > >those emails I said that performance hadn't changed very much to make 
> > >it
> > >worthwhile.
> > >
> > >So I wonder what changed which makes you say the above?
> > 
> > Truth to tell, on my Pg box, I didn't notice much improvement in 
> > performance, either. :-(
> > 
> 
> 
> 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).

-- 
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/20030504/a53f8b89/attachment.sig>