3.6.13. Optimise (Delayed Joins)

  • SELECT FROM (SELECT id FROM ... LIMIT 0,10)
    • Subqueries not the silver bullet
    • Often not cached or indexed
  • Views help manage complex relationships but not performance
  • Changing picture
    • Even between MySQL 5.0 and 5.1
    • MySQL 6.0
      • Falcon (transactional) Storage
      • Better subquery optimisation