Tom Tucker

168 reputation

	168 reputation	bio	website		visits	member for	2 years, 2 months
5 badges		location			seen	Nov 9 '12 at 0:27

15 Actions

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	revised	How do I transition from physics and math to programming? edited body
Mar 21	awarded	Teacher
Mar 18	comment	How do I transition from physics and math to programming? @SK-logic +1 and investment banks pay quants really, really well.
Mar 18	answered	How do I transition from physics and math to programming?
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