distroseries +packaging and +needs-packaging could cache

Bug #599818 reported by Curtis Hovey
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Launchpad itself
High
Unassigned

Bug Description

Recent schema changes make data retrieval for +packaging and +needs-packagin much faster, but. packages are added/removed from +packaging and +needs-packaging about 10 times a day. The queries rarely return *new* information. A 30 minute public cache will help the pages display quicker.

Related branches

Revision history for this message
Ursula Junque (ursinha) wrote : Bug fixed by a commit
tags: added: qa-needstesting
Changed in launchpad-registry:
status: In Progress → Fix Committed
Curtis Hovey (sinzui)
tags: added: qa-bad
removed: qa-needstesting
Revision history for this message
Curtis Hovey (sinzui) wrote :

The cache rule that were applied by the first branch are ineffective. Each entry in the listing is cached, but the view is still calling the expensive query. A change to an entry usually means it is linked to an upstream, and thus disappears from the listing. The entire table should be cached; move the cache instruction before the repeat.

Changed in launchpad-registry:
status: Fix Committed → In Progress
Curtis Hovey (sinzui)
Changed in launchpad-registry:
status: In Progress → Fix Committed
Curtis Hovey (sinzui)
tags: added: qa-ok
removed: qa-bad
Curtis Hovey (sinzui)
Changed in launchpad-registry:
status: Fix Committed → Fix Released
Curtis Hovey (sinzui)
Changed in launchpad:
assignee: Curtis Hovey (sinzui) → nobody
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers