I am trying to understand some of the data storage and caching details of Stack Overflow.
- Are the pages build completely from redis cached data or does it need to make some db calls?
Assuming that database calls are required
How many (approximate) database calls are to be made to build a complete page?
Does the db queries executed to build page involve joins, GROUP BY kind of operations? If so how is their performance under load?
Is the db schema denormalized for performance reasons?