167 reputation
6
bio website
location
age
visits member for 3 years, 4 months
seen Oct 19 '13 at 18:44

Aug
21
awarded  Nice Question
Jul
4
accepted Banking Applications - Saving Account Balance
Jul
3
asked Banking Applications - Saving Account Balance
Apr
8
accepted Why are message view counts laggy on most web sites?
Apr
8
comment Why are message view counts laggy on most web sites?
Never thought of the last solution - very clever! That alone is worth +1.
Apr
8
comment Why are message view counts laggy on most web sites?
@Dean Harding That's wicked!
Apr
8
comment Why are message view counts laggy on most web sites?
@Dean Harding Thanks, but doesn't it mean the table would have billions, if not trillions, of records for a web site even with moderate traffic, much less youtube? With such massive records, I suspect that SELECT COUNT(*) would have a performance impact on the DB even if it runs only every 10 minutes. This would also require more disk space for the database and backup. I'm not saying locking the table on every page hit is any better, but I just find it hard to understand how big web sites would handle such huge data.
Apr
8
asked Why are message view counts laggy on most web sites?
Mar
21
awarded  Editor
Mar
21
awarded  Teacher
Mar
18
awarded  Scholar
Mar
18
accepted Class Naming in Stock Trading Application
Mar
15
awarded  Supporter
Mar
15
awarded  Student
Mar
15
asked Class Naming in Stock Trading Application