Typo3 and Joomla in china

Query Performance Optimization

Jul 23, 2010 Database
Posted by admin

1.Slow Query Basics:Optimize Data Access

• Are you asking the database for data you do not need?
• Is MySQL examing too much data?(index solution)

2.Ways to restructure queries

• Complex queries Versus Many queries(few queries)
• Chopping up a query
• Join Decomposition(
  • When application joins may be more efficient
  • you cache and reuser a lot of data from earlier queries
  • you use multiple MyISAM tables
  • you distribute data across multiple severs
  • you replace joins with in() lists on larger tables
  • a  join refers to the same table multiple times
  • )