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.
|
|