[rt-users] RT performance or feature request

[Schultz, Eric]

> I have a ticket containing a very deep hierarchy tree, around 5,000 
> tickets, but with only 50 direct children.  Disastrously, it takes RT 
> around 20 minutes to opening the ticket.
> 
> When I dived into this problem, I found that the time was spent on 
> querying mysql database, around 15 minutes.
> 
> Do you have any idea on improving the performance of mysql.
> 
> My box: 4G mem, dual Intel 2.8 G.
> 
> If we can't improve the performance of mysql, is it possible to list 
> only the direct children?
> 
> Thanks for any hint.
> 
> - Wang

Why do you have such a deep/large heirarchy for one ticket?  You really
shouldn't do this in the future, I don't think there is anything you can
do in the backend to speed things up.

Eric Schultz
United Online