NYCPHP Meetup

[Hans Zaunere]

> Prepare/execute doesn't improve portability.  Plus, I have a feeling you
> are wasting resources.  Prepare/execute is only efficient when you do one
> prepare of the query and then will be executing that the same exact query
> (without changing table/column names) multiple times.

An additional benefit is when dealing with larger data fields, such as BLOB and TEXT.  Column data in prepared statements don't need to be escaped, which can improve performance significantly.  Also, for very large data sets, you can enable chunk sending of the data, which can also improve performance and network issues.

H