Hi, On Tue, Jun 8, 2010 at 12:47 AM, Bill Karwin <b...@karwin.com> wrote: > Keep in mind that the round-trip you fear incurs too much overhead is > actually not always a problem. This article shows that at least in some > cases, a prepared MySQL query actually runs 14% _faster_ than a non-prepared > query: > http://www.mysqlperformanceblog.com/2006/08/02/mysql-prepared-statements/ >
After reading the article, I think 'Query cache does not work" is a strong enough reason not to use prepare statement.