[rt-users] Performance Issue - RT 3.xx

[Phil Homewood]

Greg Kuhnert wrote:
> We are running 3.04 :-) Our admin upgraded yesterday....

Sorry.

[me]
> You really really want to upgrade your RT3 instance to 3.0.4. The query
> in question was rewritten because mysql's optimiser treated it so
> woefully. You should see a decimal order of magnitude improvement.

I take that back; the query you posted wasn't the one that
was optimised in 3.0.4. I misparsed. I shall now crawl back
into my shell. :-)

-- 
Phil Homewood, Systems Janitor, http://www.SnapGear.com
pdh at snapgear.com Ph: +61 7 3435 2810 Fx: +61 7 3891 3630
SnapGear - Custom Embedded Solutions and Security Appliances