Product:EntryResource:get_timeline timeline graph timeout on obsolete-junk project

[Edwin Grubbs]

OOPS-1769S339

SQL time: 6252 ms
Non-sql time: 4630 ms
Total time: 10882 ms
Statement Count: 311

5. 3065 21ms SQL-launchpad-main-master 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.productseries = %s ORDER BY milestone_sort_key(Milestone.dateexpected, Milestone.name) DESC LIMIT 20
6. 3089 18ms SQL-launchpad-main-master 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.productseries = %s ORDER BY milestone_sort_key(Milestone.dateexpected, Milestone.name) DESC LIMIT 20

- its just bad repetitive code.

The https://staging.launchpad.net/obsolete-junk/+series page tries to load a timeline graph with all the obsolete series, which times out. Here is the API call that it is making:
https://staging.launchpad.net/api/devel/obsolete-junk?ws.op=get_timeline&include_inactive=true

The project +index page doesn't have this problem because its timeline graph does not include obsolete series.

[Launchpad QA Bot (lpqabot)]

Fixed in stable r11994 <http://bazaar.launchpad.net/~launchpad-pqm/launchpad/stable/revision/11994>.