Activity log for bug #615064

Date Who What changed Old value New value Message
2010-08-08 17:09:35 Curtis Hovey bug added bug
2010-08-09 07:31:47 Robert Collins description The recent fix to imrpove the speed of the packaging portlet exposes another poor performing query. OOPS-1681EB2995 shows distroseries.getMostRecentlyLinkedPackagings() is asking for 5 tuples of (packaging, spn, product_series, product), but tis causes 238 TeamPartcipation and 207 Person queries. The problem starts when the distroseries gotten. Only one Packaging is retieved by the moment of the timeout. The recent fix to improve the speed of the packaging portlet exposes another poor performing query. OOPS-1681EB2995 shows distroseries.getMostRecentlyLinkedPackagings() is asking for 5 tuples of (packaging, spn, product_series, product), but tis causes 238 TeamPartcipation and 207 Person queries. The problem starts when the distroseries gotten. Only one Packaging is retieved by the moment of the timeout.
2010-08-10 00:25:03 Curtis Hovey launchpad-registry: milestone 10.08 10.09
2010-08-10 01:13:43 Curtis Hovey summary distroseries+index oops getMostRecentlyLinkedPackagings distroseries+index oops getting the count of linked packages
2010-08-10 15:52:53 Curtis Hovey launchpad-registry: milestone 10.09 10.08
2010-08-10 15:54:55 Curtis Hovey launchpad-registry: status Triaged Fix Committed
2010-08-10 15:55:05 Curtis Hovey launchpad-registry: assignee Robert Collins (lifeless)
2010-08-12 14:37:09 Curtis Hovey launchpad-registry: status Fix Committed Fix Released