[rt-users] RT performance or feature request

[lwang]

Schultz, Eric wrote:
>>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

This tree was migrated from Bugzilla.  Typically, we have hundreds of 
tickets under a tree.

Because of the simplicity of Bugzilla, it can handle such an extreme 
without difficulty.