To scale at Digg they followed a set of practices very similar to those used at eBay. No joins, no foreign key constraints (to scale writes), primary key look-ups only, limited range queries, and joins were done in memory. When implementing the comment feature a 4,000 percent increase in performance was created by sorting in PHP instead of MySQL. All this effort required to make a relational database scale basically meant you were using a non-relational database anyway. So why not just use a non-relational database from the start?
[via High Scalability]
-
DIGG: 4000% PERFORMANCE INCREASE BY SORTING IN PHP RATHER THAN MYSQL
-
iPlayPhone is Free!!
in AppsIn celebration of one year in the app store iPlayPhone is now free!!!
[iTunes Link]
-
Link Love or Holy Crap Sites Keep Linking iPlayPhone
in AppsI want to shout out a couple of the sites that have been promoting iPlayPhone recently.
Matt Howie – creator of metafilter – gave iPlayPhone mention in his roundup of Recommended Kid Games.
AssociatedContent – a site I’d never heard of, but one that evidently gets over 24,000,000 visitors per month – ranked iPlayPhone #2 “Best Phone App for Kids on the iPhone.”