[rt-users] Slow loading of long tickets in 3.6.3

[Justin Hayes]

Thanks for the advice Roy, but I think I'd already tried that at some  
point in the past:

   <tr>
     <td colspan="4" class="content <%perl> $m->print('hidden') if  
$Collapsed==2;</%perl>" id="txn-body-<%$Transaction->id%>">
%# if ($Transaction->CustomFieldValues->Count) {
%#      <& /Elements/ShowCustomFields, Object => $Transaction &>
%# }
% $m->comp('ShowTransactionAttachments', %ARGS, Parent => 0) unless  
($Collapsed==1 ||!$ShowBody);
     </td>
   </tr>

Justin

On 28 Apr 2009, at 11:00, Raed El-Hames wrote:

> Justin;
>
> I 've had similar slow loading tickets in the past, and it turned  
> out (in my case) the problem was with transactions custom fields, do  
> you use those?? if you don't you can comment  out the following  
> lines from Ticket/Elements/ShowTransaction
>
> 65 % if ($Transaction->CustomFieldValues->Count) {
> 66       <& /Elements/ShowCustomFields, Object => $Transaction &>
> 67 % }
>
> The numbers you see there are the line numbers
>
> Roy
>
>
> Justin Hayes wrote:
>> Hi,
>>
>> Some of our tickets can get pretty long and the longer they get  
>> the  longer the page takes to load. So for a long ticket with say  
>> 100  comments/replies and assorted status changes etc it might take  
>> 10+  seconds to render.
>>
>> A lot of the time seems to be looping over every transaction,  
>> checking  permissions etc etc, I guess maybe to decide whether to  
>> display the  reply/comment options and other things.
>>
>> Have any improvements been made to the history display code in 3.8?  
>> I  would have thought it was more sensible to check permissions  
>> once for  the ticket and then quickly render all the attachments,  
>> but I'm sure  that's a simplistic view of it.
>>
>> Any thoughts welcome!
>>
>> Justin
>>
>> -------------------------------------------------
>> Justin Hayes
>> Orbis Support Manager
>> justin.hayes at orbisuk.com
>>
>>
>>
>>
>> _______________________________________________
>> 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
>>


-------------------------------------------------
Justin Hayes
Orbis Support Manager
justin.hayes at orbisuk.com