User Details like in stackoverflow at the bottom of each question and answer

Question

Hi, I was wondering how stackoverflow.com implemented user info below each post , based on data dump of stackoweflow in Posts table are : OwnerDisplayName and OwnerUserId records, but what about reputation score s and badges ? are there made joins to user table on each post ? Is there other way to get such info? Maybe it is being kept in server cache ? lets say we have got guestion and 20 answers to in so we have to make join for each answer? performance of it would be very poor? Additionally fo you think questions are cached by outputcache ? or it is only data caching ? How would you implement that feautre?

Answer 1

I'd cache the snippet of HTML for each user, and update the cache when the user's rep or badge info changed.