2011-05-15 22:26:56 |
Robert Collins |
description |
1 SELECT Milestone.active, Milestone.codename, Milestone.dateexpected, Milestone.distribution, Mile ... t, Milestone.productseries, Milestone.summary FROM Milestone WHERE Milestone.id = $INT LIMIT $INT:
GET: 1 Robots: 1 Local: 0
1 https://launchpad.net/libpng/main/1.2.9beta6/+rdf (ProductRelease:+rdf)
OOPS-1900M664 |
1 SELECT Milestone.active, Milestone.codename, Milestone.dateexpected, Milestone.distribution, Mile ... t, Milestone.productseries, Milestone.summary FROM Milestone WHERE Milestone.id = $INT LIMIT $INT:
GET: 1 Robots: 1 Local: 0
1 https://launchpad.net/libpng/main/1.2.9beta6/+rdf (ProductRelease:+rdf)
OOPS-1900M664
The repeated statements section has
Reps Total time Average time Saving Database id Statement
1 501 10856 21 10835 SQL-launchpad-main-slave
SELECT Milestone.active,
Milestone.codename,
Milestone.dateexpected,
Milestone.distribution,
Milestone.distroseries,
Milestone.id,
Milestone.name,
Milestone.product,
Milestone.productseries,
Milestone.summary
FROM Milestone
WHERE Milestone.id = $INTLIMIT $INT
Thats 501 late-lookups of milestones. There are 777 milestones for libpng on production, and as this rdf is for a single release/milestone it suggests that the traversal is examining all the milestones in a list rather than doing a dict-style dereference. |
|