[rt-users] RT performance or feature request

[Ruslan Zakirov]

On 4/3/06, lwang <lwang at clusterfs.com> wrote:
> Hi there,
> Now RT will list all children of a ticket including non-direct children.
>
> 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.
Heh :( Most probably want to turn on logging in your DB.
Start from mysql slow queries log.

>
> 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.
You can grab list of the queries RT runs to show you that ticket and
check if all the queries use indexes.


>
> 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?
Yep. You can hack RT a little.

>
> Thanks for any hint.
>
> - Wang
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>
>
> We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
>


--
Best regards, Ruslan.