Some javascript/style in this post has been disabled (
why?)
Out of curiosity, is named binding select statements faster for
repeated queries than using the regular quoted string syntax?
The API docs reference these 3 methods:
// simplest but non-secure
$select->where("id = $id");
// secure (ID is quoted but matched anyway)
$select->where('id = ?', $id);
// alternatively, with named binding
$select->where('id = :id');
In the last one, the actual value isn't quoted into the string, so you
end up with a prepared statement without the values embedded, while the
former two will result in a completely different query in each
iteration.
Not knowing the ins and outs of query caching, I would assume that the
3rd option would be the fastest, since the query would only need to be
prepared once, and then could be reused.
Can anyone confirm this?
Cheers,
David