Tech Presentations

Presentation about Flickr using PHP (PDF, PPT)

Looks like flickr is BIG application and they managed to use PHP and MySQL to develop it.

Interesting quotes:

• Big system:
  • One programmer, one designer, etc.
  • ~60,000 lines of PHP code
  • ~60,000 lines of templates
  • ~70 custom smarty functions/modifiers
  • ~25,000 DB transactions/second at
  • ~1000 pages per second at peak
• Snapshot of db1.flickr.com
  • SELECT’s 44,220,588
  • INSERT’s 1,349,234
  • UPDATE’s 1,755,503
  • DELETE’s 318,439
  • 13 SELECT’s per I/U/D
• Stateless
  • We can bounce people around servers
  • Everything is stored in the database
  • Even the smarty cache\
  • “Shared nothing”
  • (so long as we avoid PHP sessions)
• JOIN’s are slow
• Normaliseddata is for sissies
• Keep multiple copies of data around
• Makes searching faster
• Have to ensure consistency in the application logic