forgot patch
On 12/6/06, Ruslan Zakirov <[EMAIL PROTECTED]> wrote:
On 11/30/06, Filip Rembialkowski <[EMAIL PROTECTED]> wrote:
[snip]
> >
> > That sounds surprisingly high. But you're also testing with
> > an...older RT. And I know we've made some big performance
> > improvements since then. I can't guarantee that we've fixed whatever
> > you're running into, but coming up to 3.4.6 or 3.6 is strongly
> > recommended.
> >
> >
> actually i discovered this while evaluating RT 3.6.1 :)
> I was talking about 3.4.1, because the results are very similar.
>
> to be precise, I made this test again, just for a single home page view,
> and have posted SQL log for single home page view here:
> http://depesz.com/various/rt-3.6.1-homepage-view-sql-log.html
> if you look at this, you will know what I mean
Thanks for great report and good representation. Could you spend some
time and write instructions about how to create such report? :)
>
> so the question is still valid.
> is it needed to ask all these queries?
> can we optimize it somehow?
yep, at least get rid of the second line in your log. try attached
patch. don't forget to purge mason cache.
>
> greets,
> Filip
>
>
--
Best regards, Ruslan.
--
Best regards, Ruslan.
=== html/Elements/QueueSummary
==================================================================
--- html/Elements/QueueSummary (revision 4247)
+++ html/Elements/QueueSummary (local)
@@ -58,7 +58,7 @@
<tr class="<% $i%2 ? 'oddline' : 'evenline'%>" >
<td><a href="<% $RT::WebPath%>/Search/Results.html?Query=<%$all_q%>" title="<% $queue->{Description} %>"><%$queue->{Name}%></a></td>
% for my $condition (@$conditions) {
-% $Tickets->FromSQL($queue_cond.$condition->{cond}),
+% $Tickets->FromSQL( "Queue = $queue->{id} AND ". $condition->{cond} );
<td align="right"><a href="<% $RT::WebPath%>/Search/Results.html?Query=<%$queue_cond.$condition->{cond}%>"><% $Tickets->Count %></a></td>
% }
</tr>
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
