Comment 23 for bug 590708
Revision history for this message
| Stuart Bishop (stub) wrote Re: [Bug 590708] Re: DistroSeries.getBuildRecords often timing out | #23 |
© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
0e1f616
(Get the code!)
On Wed, Jul 21, 2010 at 1:38 AM, Данило Шеган <email address hidden> wrote:
> Warm caches seem to help even on production, and my suggested query runs
> much faster after caches are warm: http://
I have so far been unable to beat Danilo's optimization.
You might want to confirm that the query is actually doing what you
want btw. Looking at the COUNT query lifeless cites (the first), not
only are there two repeated joins in the WHERE clause, but there is
also a spurious status clause ('status <> 1 OR datefinished IS NOT
NULL' is irrelevant, as it is overridden by the more restrictive
'status=2' clause. This might indicate some missing brackets
somewhere.
--
Stuart Bishop <email address hidden>
http://