Newsgroups: php.internals Path: news.php.net Xref: news.php.net php.internals:52126 Return-Path: Mailing-List: contact internals-help@lists.php.net; run by ezmlm Delivered-To: mailing list internals@lists.php.net Received: (qmail 78741 invoked from network); 1 May 2011 00:01:14 -0000 Received: from unknown (HELO lists.php.net) (127.0.0.1) by localhost with SMTP; 1 May 2011 00:01:14 -0000 Authentication-Results: pb1.pair.com header.from=pierre.php@gmail.com; sender-id=pass; domainkeys=bad Authentication-Results: pb1.pair.com smtp.mail=pierre.php@gmail.com; spf=pass; sender-id=pass Received-SPF: pass (pb1.pair.com: domain gmail.com designates 209.85.215.170 as permitted sender) DomainKey-Status: bad X-DomainKeys: Ecelerity dk_validate implementing draft-delany-domainkeys-base-01 X-PHP-List-Original-Sender: pierre.php@gmail.com X-Host-Fingerprint: 209.85.215.170 mail-ey0-f170.google.com Received: from [209.85.215.170] ([209.85.215.170:50818] helo=mail-ey0-f170.google.com) by pb1.pair.com (ecelerity 2.1.1.9-wez r(12769M)) with ESMTP id 8C/1C-10915-8C2ACBD4 for ; Sat, 30 Apr 2011 20:01:13 -0400 Received: by eyf5 with SMTP id 5so1465528eyf.29 for ; Sat, 30 Apr 2011 17:01:08 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:in-reply-to:references:date :message-id:subject:from:to:cc:content-type; bh=FB4zPsfSnSoXoG4MucDUdgmEKwqYC3Le31IsIeXRKWk=; b=OQkqkAmjuSIyAPCXnWBBjsDHRy2l5BBiyMPEiwfIprZfhBFmw1vv8OcpZyjTk74hML aafbWmJkNN/i+LWvxxR5wYloLXHA+JI/Tgugw7Wnc7qwUG5WMumi1lWgxIq9hPTA4/5T bChvf3RkNOb6h1UrtGDjNld/FcFAG+mdw3AqU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=h+naI1o61AjYPnhCyaVOZexsvV2jARUhTtz6jLunFVIamTeGaN3FyO1ZvcykptDb5V jtqzwlavdT5vw6wcgpQv6hyy7UoWFFTC0q2eX5/1NJ1Qj75DHR9yox7VD6iHXI/BYsyU Aznsy+bDKTq9/M0qiRHEklXxcxhbyFt6wCl7c= MIME-Version: 1.0 Received: by 10.14.50.196 with SMTP id z44mr2730392eeb.227.1304208067148; Sat, 30 Apr 2011 17:01:07 -0700 (PDT) Received: by 10.14.45.3 with HTTP; Sat, 30 Apr 2011 17:01:07 -0700 (PDT) In-Reply-To: References: <4DBC2D1B.10302@lerdorf.com> <4DBC4885.7010209@sugarcrm.com> <4DBC4C9A.2050502@lerdorf.com> <1304193525-sup-1492@fewbar.com> Date: Sun, 1 May 2011 02:01:07 +0200 Message-ID: To: Ferenc Kovacs Cc: Clint Byrum , internals Content-Type: text/plain; charset=ISO-8859-1 Subject: Re: [PHP-DEV] Change Request: Make PDO default to not emulate prepared statements for MySQL From: pierre.php@gmail.com (Pierre Joye) hi, It is also important to keep in mind that there are a growing alternative to Oracle's mysql, so focusing only on Oracle plans is not necessary a good thing to do. That being said, it seems that we have an agreement to change this behavior in trunk. It is a documentation matter then. There is no need to argue to death about this issue. And last but not least, let the mysql developers reply and decide what they want to do. Cheers, On Sat, Apr 30, 2011 at 11:26 PM, Ferenc Kovacs wrote: > On Sat, Apr 30, 2011 at 10:05 PM, Clint Byrum wrote: > >> Excerpts from Rasmus Lerdorf's message of Sat Apr 30 10:53:30 -0700 2011: >> > On 04/30/2011 10:36 AM, Stas Malyshev wrote: >> > > Hi! >> > > >> > >> Do you realize why we did this in the first place? The common versions >> > >> of MySQL in use out there are not very clever when it comes to the >> > >> native prepared statement handling. First, there is no prepared >> > >> statement cache, so there is no benefit to doing them natively, but >> > > >> > > Since 5.1.17 there is: >> > > http://dev.mysql.com/doc/refman/5.1/en/query-cache-operation.html >> > > And 5.1.17 is 4 years old already. >> > >> > People upgrade their databases even slower than they upgrade their PHP. >> >> That said, MySQL 5.0 is only in "Extended Support"[1] (read: security >> only) from Oracle, and will likely be deprecated to full EOL at some >> point in the near future. I think its fair to say that if something is >> a massive problem for a version that the authors don't even support, >> its probably ok to leave those users behind with defaults, as long as >> you give them a way to turn it off. So maybe this could be considered >> blocked only by 5.0's EOL. >> >> -- >> [1] http://www.mysql.com/support/eol-notice.html >> >> > if oracle keeps the original lifecycle of the mysql product line, then the 2 > year extended support is 2 years from the eol of the active support, so it > means that 5.0 extended will end 2011 dec 31. > but the extended support is only available for those who bought the premium > support, so for the rest of us, 5.0 is already EOL > > Tyrael > -- Pierre @pierrejoye | http://blog.thepimp.net | http://www.libgd.org