Cache total number of questions

VERIFIED FIXED in 2011-06-14

Status

VERIFIED FIXED
7 years ago
7 years ago

People

(Reporter: jsocol, Assigned: jsocol)

Tracking

unspecified
2011-06-14

Firefox Tracking Flags

(Not tracked)

Details

(Whiteboard: [qa-])

(Assignee)

Description

7 years ago
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)

Updated

7 years ago
Assignee: nobody → james
Target Milestone: --- → 2011-06-14
(Assignee)

Comment 1

7 years ago
https://github.com/jsocol/kitsune/commit/ddd6d495
Status: NEW → RESOLVED
Last Resolved: 7 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.