webtuesday: Finding Order in Execution April 10, 2007

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