Launchpad itself

  1. Bug #615064
  2. Comment #0

Comment 0 for bug 615064

Revision history for this message
Curtis Hovey (sinzui) wrote : distroseries+index oops getMostRecentlyLinkedPackagings

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.