[rt-users] Ludicrously slow queries on custom fields

Tony Bowden rt at tmtm.com
Tue Oct 17 02:04:14 EDT 2006


On Mon, Oct 16, 2006 at 03:55:11PM -0400, Jesse Vincent wrote:
> > In further investigation we found a line in the DBIx::SearchBuilder
> > Changes file from earlier this year that says:
> >   * Allow ORs on left joins
> > It's conceivable that that was upgraded with mysql - is it possible that
> > this change might have made the old 3.2.2 query work differently? 
> It's possible, but I couldn't say for sure. Try backing down and see if
> it's better?

Reverting SearchBuilder fixed our problem. 

Looks like 3.2.2 constructed queries on custom fields badly, but as SB
couldn't cope with them, then it wasn't really a problem!  :)

Looks like we just need to be careful not to upgrade SearchBuilder until
we can upgrade RT as well...

Thanks,

Tony




More information about the rt-users mailing list