I read an article on the Trello tech stack, under the section "MongoDB", it states the following:
[...] One of the coolest and most performance-obsessed teams we know is our next-door neighbor and sister company StackExchange. Talking to their dev lead David at lunch one day, I learned that even though they use SQL Server for data storage, they actually primarily store a lot of their data in a denormalized format for performance, and normalize only when they need to.
But it doesn't cover the above statement from the blog, and the blog was written 4 years ago, January 19th, 2012 to be exact.
- Does SE store its data in a denomalised format then normalise it in SQL Server when needed? (Has it ever?)
- If so then how does this work? At what point is the data normalised? After a timeframe, event, whatever?