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
Request Tracker — Best Practical Solutions – 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
–
Request Tracker... So much more than a help desk — Best Practical Solutions – 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
Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.