On 10/17/05, Lukas Kahwe Smith mls@pooteeweet.org wrote:
Note that currently MDB2 only natively supports prepared queries in the oci8, ibase and mysqli driver. I am planning on adding native prepared query support for the pgsql driver eventually.
For all other drivers its emulated, including proper quoting of course.
This is expected behavior of course ;D
As for caching prepared statements this is a tricky topic. PHP obviously has to rely on the database to do this properly for now and for example with pgsql you run into issues, because pgsql expects the middleware to keep the handle to the prepared statement.
Caching is NOT on the driver end but on the server end. For the length of the connection, and possibly longer, prepared queries are given a unique ID and can be held in a planned state until they get cleared. It changes db to db as to how long or if they are even cached. The driver MAY do this, but it is not the responsibility of the driver.
regards, Lukas
BTW MDB2 is pretty sweet looking.
-- Christopher A. Watford christopher.watford@gmail.com