Re: Package proposal: PHP mysqlnd connection multiplexing plugin

Hi, As I understand them, prepared statements are compiled once per connection with regards to the query plan. I guess using this extension would mean prepared statements would be compiled only once per connection pool in a different way the query cache works, is that right? In that sense, I can see great value for a multiplexed connection able to use prepared statements. Best regards, -- Guillaume Rossolini On Fri, Aug 24, 2012 at 8:32 PM, Johannes Schlüter < johannes.schlueter@oracle.com> wrote: > On Fri, 2012-08-24 at 20:20 +0400, Alexey Zakhlestin wrote: > > On 24.08.2012, at 17:14, Ulf Wendel <ulf.wendel@oracle.com> wrote: > > > > > The PDO_MySQL calls PDO::query(), PDO::exec(), PDO::prepare() are > > > covered, if PDO::ATTR_EMULATE_PREPARES is set. Although this should > > > cover many use cases it does not cover all. > > > > So, it won't work with real prepared statements. Right? > > Is that temporary limitation? > > Yes that is a current limitation. Doing multiplexing with prepared > statements is a bit more complicated as one has to do more house keeping > in order to make sure statement handles match and we're not wasting > resources by keeping handles at life for too long. The initial release > is to see whether there is potential for this at all. Depending on the > feedback we might extend it, or maybe somebody from the community loves > it and wants to extend it. > > johannes > -- > MySQL Engineering, MySQL Connectors Team > ORACLE Deutschland B.V. & Co. KG, Riesstr. 25, D-80992 München > Registergericht: Amtsgericht München, HRA 95603 > > > -- > PECL development discussion Mailing List (http://pecl.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >