timeouts on +packages

Bug #607934 reported by Robert Collins
This bug report is a duplicate of:  Bug #669723: archive:+packages timeout. Edit Remove
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Launchpad itself
Triaged
High
Unassigned

Bug Description

https://lp-oops.canonical.com/oops.py/?oopsid=OOPS-1662EB444 -
SQL time: 8959 ms
Non-sql time: 6450 ms
Total time: 15409 ms
Statement Count: 578

looks like death by sql to me.

Changed in soyuz:
status: New → Triaged
importance: Undecided → High
tags: removed: oops
Revision history for this message
Robert Collins (lifeless) wrote :

So, this page scales at 4 requests per page, so a mere 100 builds into a PPA -> 400 queries. It starts at 47 which is improvable too. The relevant template is lib/lp/soyuz/templates/archive-macros.pt, with the source-package-list macro.

tags: added: pg83
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.