Closed
Bug 653264
Opened 14 years ago
Closed 14 years ago
Reduce number of queries on /questions
Categories
(support.mozilla.org :: Questions, task, P2)
support.mozilla.org
Questions
Tracking
(Not tracked)
VERIFIED
FIXED
2.8.2
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.
Assignee | ||
Comment 1•14 years ago
|
||
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-]
You need to log in
before you can comment on or make changes to this bug.
Description
•