[rt-users] 2.0.9 bogs with >10K tickets
darren at dazza.org
Thu Dec 20 18:08:35 EST 2001
>>>>> 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?
More information about the rt-users