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
Status: NEW → RESOLVED
Last Resolved: 7 years ago
Resolution: --- → FIXED
Closed as [qa-]
Status: RESOLVED → VERIFIED
You need to log in before you can comment on or make changes to this bug.