[rt-users] 2.0.9 bogs with >10K tickets

[Jesse Vincent]

It's probably worth turning on full query logging and doing some query analysis to see what other 
indices would be helpful. I'd love to hear what you find.

	-j


On Thu, Dec 20, 2001 at 06:08:35PM -0500, Darren Nickerson wrote:
> 
> >>>>> On Thu, 20 Dec 2001, "Darren" == Darren Nickerson wrote:
> 
> 
>   Darren> Things have definitely improved!! Thanks!
> 
> Substring searches by requestor and bulk updates on the returned results
> still aren't really feasible somehow though, wven with the new schema and
> indices. MySQL's processlist shows:
> 
> | 16 | rt2  | localhost | rt2 | Query   | 326   | Copying to tmp table | 
> SELECT DISTINCT main.* FROM Tickets main, Watchers Watchers_1, Watchers W
> atchers_3  LEFT JOIN Users  |
> 
> And man . . . . does it ever chug. 3+ minutes even. Normal?
> 
> -d
> 
> 
> 

-- 
http://www.bestpractical.com/products/rt  -- Trouble Ticketing. Free.