PPA page loads very slowly

Bug #190984 reported by Steve Magoun
This bug report is a duplicate of:  Bug #246940: PPA index page timeouts. Edit Remove
2
Affects Status Importance Assigned to Milestone
Launchpad itself
Triaged
Medium
Celso Providelo

Bug Description

The PPA for the ubuntu-mobile team (https://edge.launchpad.net/~ubuntu-mobile/+archive ) takes a very long time to load - sometimes on the order of 1min (30sec is more common). A big part of the time seems to be query execution on the server, rather than transmission of the page.

As of right now (11Feb2008 1600UTC) the PPA page reports it has 29 source packages and 869 binary packages in it, and the source of the PPA web page contains this at the bottom: <!-- at least 4594 queries issued in 19.75 seconds -->

230 queries/sec sounds impressive, but with an average of >5 queries/package the load time is going to increase as we continue to use the PPA. It's already frustrating to wait 30sec to load the page.

Can LP be more aggressive about caching the data used to build the PPA page? Seems to me that it should be possible to cache the data in a way that subsequent page views don't require so many queries, since the data is relatively static and (I assume) each user sees the same data when viewing the page.

Tags: lp-soyuz ppa ui
Celso Providelo (cprov)
Changed in soyuz:
assignee: nobody → cprov
importance: Undecided → High
milestone: none → 1.2.3
status: New → Triaged
Changed in soyuz:
milestone: 1.2.3 → 1.2.4
Revision history for this message
Julian Edwards (julian-edwards) wrote :

Some optimisations to the number of queries was made, reducing them to about 400. Reducing to medium priority for now; although we'll still be doing the caching fix at some point.

Changed in soyuz:
importance: High → Medium
milestone: 1.2.4 → none
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.