Posted by Chris White on 04/30/05 11:01

Mark wrote:
> hello!
>
> mysqli in PHP5 comes with prepared statements functionality. However,
> without persistent connections or connection pooling in this code
> library, one has to ask: why bother?
>
> are prepared statements 'remembered' by the server for a while between
> connections, so that new connections can take advantage of them, or are
> they really only useful for those pages/requests that are executing a
> huge amount of DML in a single shot.
>
>
> thanks!
> mark.
>
>
Somewhat difficult to explain in an easy statement right now so I'll let
this page do the talking:

http://www.zend.com/php5/articles/php5-mysqli.php

from what I can tell it isn't working with persitant connections, it's
making it easy to address certain database query results to various
variables, as well as letting the server know how the data will be
encoded ahead of time (making things faster ?). I've been playing
around with mysqli and mysql 5 beta for awhile, but have only got the
connection parts up and running so far. I'll find out more later.

Chris White

[Back to original message]