How does Stack Overflow keep track of the number of questions under a tag as well as the number of votes, views, answers per question, etc? I'm just eager to know if they maintain a separate table or do a count query every time.
What is meta?
- Any Stack Exchange user can ask a question
- The community provides support, votes on ideas, and reports bugs
- Your voice helps shape the way Stack Exchange operates
Not quite a duplicate, but a fellow MSO user posted an interesting writeup about this at Dissecting the Stack Overflow views counter. Excerpt:
Just use a database of questions and answer.
Each user has a unique ID to query on.