Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:52127
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Received-SPF: error (pb1.pair.com: domain oracle.com from 148.87.113.121 cause and error)
References: <BANLkTimtRdY_+Jj46jFEqkseuz7WD1ZPZQ@mail.gmail.com>
In-Reply-To: <BANLkTimtRdY_+Jj46jFEqkseuz7WD1ZPZQ@mail.gmail.com>
Mime-Version: 1.0 (iPod Mail 8H7)
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=us-ascii
Message-ID: <05C24951-0115-411C-89AA-E599D80EC6FF@oracle.com>
Cc: "internals@lists.php.net" <internals@lists.php.net>
Date: Sun, 1 May 2011 09:32:29 +0200
To: Anthony Ferrara <ircmaxell@gmail.com>
Subject: Re: [PHP-DEV] Change Request: Make PDO default to not emulate prepared statements for MySQL
From: johannes.schlueter@oracle.com (=?utf-8?Q?Johannes_Schl=C3=BCter?=)

Hi,

On Apr 30, 2011, at 17:13, Anthony Ferrara <ircmaxell@gmail.com> wrote:

> I have already reported this issue on the bug tracker:
> http://bugs.php.net/bug.php?id=3D54638

Besides the question about query cache and security there is a bit more to k=
eep in mind:

Using native prepared statements means one more round-trip between PHP and M=
ySQL which might impact performance. This is even more relevant as PDO::quer=
y will go through the PS API ... While PS uses a more compact binary protoco=
l.

Also there are still a few (minor) statements which can't be prepared in MyS=
QL where PDO will silently fall back silently to emulation. (don't have the l=
ist at hand, but should be in the docs)

Also mind that native PS still runs through PDO's SQL parser to handle place=
 holder so it won't solve all issues in there.=20

johannes=