Re:Why does digg need so many servers?
by jswinghammer on Wednesday October 13, 2010 @12:45PM
(#1787781)
Both are simple sites by any definition. The database queries for almost all the pages views are clustered index seeks (on SQL server) and in MySQL they are mostly looking up on the primary keys for the tables used (these are MyISAM tables so no clustered indexes here).
Both are equally unoptimized outside of the database queries which I believe are fairly well optimized.
No real cacheble content on either outside of the usual suspects (JS, CSS, some images)
- What do the sites do?
- How optimised are they?
- How much static/cachable content is there?
Really there is too little data for this comparison.