Closed Bug 653264 Opened 14 years ago Closed 14 years ago

Reduce number of queries on /questions

Categories

(support.mozilla.org :: Questions, task, P2)

Tracking

(Not tracked)

VERIFIED FIXED

People

(Reporter: jsocol, Assigned: jsocol)

Details

(Whiteboard: [qa-])

Even with a warm cache, the /questions list does 95 queries, including a _lot_ of repeated SELECT COUNT (not cached in cache machine for various reasons) and selecting individual related objects. We should try to get more of this page on cache, either by fragment caching or the strategy from the discussion forums.
https://github.com/jsocol/kitsune/commit/239a71e Goes from 95->21 queries on a warm cache, and keeps a lot more on cache.
Status: NEW → RESOLVED
Closed: 14 years ago
Resolution: --- → FIXED
Whiteboard: [qa-]
Closed as [qa-]
Status: RESOLVED → VERIFIED
You need to log in before you can comment on or make changes to this bug.