Application Design
	• Use MySQL extensions for speed – REPLACE queries – Bundled INSERT queries – Multi-table deletes – User variables • Use logging to track bottlenecks • Don’t perform unnecessary queries – Cache data (static lookup tables) – Use the Query Cache if you must • Benchmark your application – Know where the bottlenecks are – Know how a slow db affects your application
			Copyright 2003, Jeremy Zawodny