logo
  • About us
  • Services
  • Products
  • Work
  • Contact

Feedback

In Focus

  • Flash XML slideshow
  • Database training

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
‹ 3.6.12. Optimise (Limit)up3.6.14. References ›
  • s5 slideshow
 

 

 

Copyright 2007 Lightenna Limited

  • About us
  • Services
  • Products
  • Work
  • Contact