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
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.
gocept gmbh & co. kg - schalaunische strasse 6 - 06366 koethen/anhalt
fon. +49 3496 3099112, +49 179 1463644
fax. +49 3496 3099118