Application Design
• Use prepared queries and placeholders
– MySQL doesn’t yet support them
– Your API may
– When MySQL does, you benefit!
– The API may be more efficient anyway
– The Query Cache may benefit right away
SELECT name, address, state, zip
  FROM customers
 WHERE id = ?
Copyright 2002, Jeremy Zawodny (Jeremy@Zawodny.com)