Regular monthly webtuesday meeting - target audience: web nerds / professionals
Talk: Finding Order in Execution by Lukas Smith
That 5 table join is taking 30 seconds and you do not know why? EXPLAIN is the tool of choice to getting to the bottom of your performance issues. As part of this talk we will go through the necessary jargon, algorithms and tricks to optimize SQL queries. Particular focus will be put on finding the optimal execution plan order and how to get the database to follow this optimal order. The information provided will be useful to users of any database, but MySQL and PostgreSQL will be used as examples.
Official Website: http://webtuesday.ch/meetings/20070410
Added by harryf on March 14, 2007