New experimental searchbuilder

This version has a garbage collection optimisation (thanks to Rob Spier)
and should implement recommended quoting for all joins on Pg and left
joins on mysql. I’d be keen to hear performance reports, though I have
no idea how any of these things will affect issues in the field.

http://fsck.com/~jesse/DBIx-SearchBuilder-0.82_query2.tar.gz

jesse

http://www.bestpractical.com/rt – Trouble Ticketing. Free.

The speed doesn’t increase. Actually you cannot really optimise those
queries in SearchBuilder I think. This is a very manual thing depending
on the indexes, expected table size etc.

If you have a Postgresql running try `explain analyze select … ’ for
exact timings.

Unfortunatly I haven’t got a clue about how to change queries in RT (well,
and I don’t like perl either), so I cannot do this by myself.On Mon, May 12, 2003 at 09:45:11PM -0400, Jesse Vincent wrote:

This version has a garbage collection optimisation (thanks to Rob Spier)
and should implement recommended quoting for all joins on Pg and left
joins on mysql. I’d be keen to hear performance reports, though I have
no idea how any of these things will affect issues in the field.

http://fsck.com/~jesse/DBIx-SearchBuilder-0.82_query2.tar.gz

Christian Zagrodnick

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

One question that I do have…

Is there a test harness for SearchBuilder so that I can take the queries and
try them out on our DB?

While I think that there is a potential for speed increases I am a little
hesitant to swap out our current working build for something that is
"experimental"

Cheers,
Paul

One question that I do have…

Is there a test harness for SearchBuilder so that I can take the queries and
try them out on our DB?

In DBIx::SearBuilder::Record, you can warn with the QueryString in the
SimpleQuery routine… but it looks like its not worth it. The change I
made was for more parenthesisation of the JOIN clause based on several
reports that doing so massively improved the system’s performance.
Sadly, it looks to be not the case.

While I think that there is a potential for speed increases I am a little
hesitant to swap out our current working build for something that is
"experimental"

Realistically, I don’t expect it to actually be worse than 0.81. I just
don’t want the whole world bothering to download it and try it.

Cheers,
Paul

-----Original Message-----
From: rt-devel-admin@lists.fsck.com
[mailto:rt-devel-admin@lists.fsck.com]On Behalf Of Jesse Vincent
Sent: Tuesday, May 13, 2003 3:45
To: rt-devel@fsck.com
Subject: [rt-devel] new experimental searchbuilder

This version has a garbage collection optimisation (thanks to Rob Spier)
and should implement recommended quoting for all joins on Pg and left
joins on mysql. I’d be keen to hear performance reports, though I have
no idea how any of these things will affect issues in the field.

http://fsck.com/~jesse/DBIx-SearchBuilder-0.82_query2.tar.gz

jesse


http://www.bestpractical.com/rt – Trouble Ticketing. Free.


rt-devel mailing list
rt-devel@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-devel


rt-devel mailing list
rt-devel@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-devel

http://www.bestpractical.com/rt – Trouble Ticketing. Free.