Launchpad itself

bugs.launchpad.net/ubuntu page is too slow (DB queries)

Bug #294672 reported by Jonathan Lange
24
This bug affects 4 people
Affects Status Importance Assigned to Milestone
Launchpad itself
Invalid
High
Unassigned

Bug Description

wgrant reported on IRC that the https://bugs.launchpad.net/ubuntu page is too slow. From the source code on edge:

<!-- at least 97 queries issued in 10.65 seconds -->

This should be cut down to < 2 seconds, or ideally < 1.

See original description
Matthew Paul Thomas (mpt)
description: updated
Revision history for this message
Daniel Hahler (blueyed) wrote :

Currently: "at least 85 queries issued in 10.44 seconds"

Changed in malone:
status: New → Confirmed
Revision history for this message
Daniel Hahler (blueyed) wrote :

Currently it says:
    At least 134 queries issued in 13.61 seconds
    Launchpad 3.1.12 (r8807)

Revision history for this message
Vikram Dhillon (dhillon-v10) wrote :

Agreed, here's a firebug report on the queries that bugs.launchpad.net makes and how long they take. Hope that's helpful here

Deryck Hodge (deryck)
Changed in malone:
status: Confirmed → Triaged
importance: Undecided → High
Revision history for this message
Stuart Bishop (stub) wrote :

Do you have a statement log such as an OOPS?

Revision history for this message
Vikram Dhillon (dhillon-v10) wrote :

@Stuart:
Will the queries that I provided be helpful in identifying the "hot-spots" that take too long

Revision history for this message
Robert Collins (lifeless) wrote :

I'm closing this because its not a current timeout bug and we're ratcheting everything down from the worst pages on. We will come back to it when the data shows this page as a key contender.

Changed in malone:
status: Triaged → Invalid
Revision history for this message
Paul Sladen (sladen) wrote :

Currently:

  At least 27 queries/external actions issued in 8.40 seconds

This should really be "Won't Fix"+"Low importance"; the issue itself still exists and remains valid, just that it's not high on the Radar.

Revision history for this message
Robert Collins (lifeless) wrote :

Currently "71 queries/external actions issued in 3.91 seconds"

It really is invalid. *if* it shows up again, we'll open a new bug. Won't fix is a statement that we won't fix it - not true. *If* there is an issue, we'll get to it. Low importance would indicate performance isn't a priority - it is. Again - we're being data driven here.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Bug attachments

Remote bug watches

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