[rt-devel] new experimental searchbuilder

[Christian Zagrodnick]

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


-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
Url : http://pallas.eruditorum.org/pipermail/rt-devel/attachments/20030513/c179a282/attachment.pgp