Trac issue tracker is slow

[William Siegrist]

On Jun 11, 2008, at 3:31 AM, Ryan Schmidt wrote:

> The Trac issue tracker is very slow, and it has been for weeks, maybe
> months.
>
> View a ticket: 10 seconds
> Preview a change to a ticket: 10 seconds
> Make a change to a ticket: 14 seconds
> Show the New Ticket form: 6 seconds
> Show the Custom Query page: 10 seconds
> Find all non-closed tickets with "mysql" in the summary: 19 seconds
>



All of the above invoke the restrict_owner code which gives us the  
selector for owner instead of a text box. The way Trac generates that  
selector is very inefficient, and the code in v0.11 (due out this  
weekend) doesnt look much better.  The feature just wasnt intended for  
such a large selector it seems.

I've tried a few things to see what could help, and the only thing  
that makes a difference is switching to the textbox. In fact, the  
tickets load as fast as every other part of trac when using the text  
field.

The benefit of the text box, aside from performance, is that people  
can assign tickets to users to prompt for more info, and tickets can  
be assigned to maintainers who are not committers.

The bad part is having to type in the maintainer's or user's name. Its  
pretty easy to find that info, via the port command or the ticket  
page, but there's a chance for typos if people dont copy/paste.

So let me know if this change is worth the performance.  If some devs  
want to see the difference, you can ping me in IRC so I can switch the  
option, let you load a few of these pages, and then switch back. Its  
quite noticeable.

-Bill








-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2421 bytes
Desc: not available
Url : http://lists.macosforge.org/pipermail/macports-dev/attachments/20080620/a197e8d3/attachment-0001.p7s