Closed Bug 661547 Opened 13 years ago Closed 13 years ago

Cache total number of questions

Categories

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

Product:
support.mozilla.org
Component:
Questions
Type:
task
Priority:
Not set
Severity:
normal

Tracking

(Not tracked)

Status:
VERIFIED FIXED
Milestone:
2011-06-14

People

(Reporter: jsocol, Assigned: jsocol)

Details

(Whiteboard: [qa-]) 

Cache Machine doesn't cache COUNTs by default because they're nearly impossible to flush. This is fine most of the time, but counting visible questions means joining questions (100k rows) to users (300k) rows and there's no real way around that.

But! The only place the total number of visible questions really comes up is for the paginator, and it's pretty much OK if the paginator thinks there are a few fewer questions than there really are. We could cache this for even 10 or 15 minutes and it would be a huge savings on every /questions view.
Assignee: nobody → james
Target Milestone: --- → 2011-06-14
https://github.com/jsocol/kitsune/commit/ddd6d495
Status: NEW → RESOLVED
Closed: 13 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.