Newsgroups: php.internals Path: news.php.net Xref: news.php.net php.internals:52124 Return-Path: Mailing-List: contact internals-help@lists.php.net; run by ezmlm Delivered-To: mailing list internals@lists.php.net Received: (qmail 58974 invoked from network); 30 Apr 2011 21:27:03 -0000 Received: from unknown (HELO lists.php.net) (127.0.0.1) by localhost with SMTP; 30 Apr 2011 21:27:03 -0000 Authentication-Results: pb1.pair.com smtp.mail=tyra3l@gmail.com; spf=pass; sender-id=pass Authentication-Results: pb1.pair.com header.from=tyra3l@gmail.com; sender-id=pass; domainkeys=bad Received-SPF: pass (pb1.pair.com: domain gmail.com designates 209.85.215.42 as permitted sender) DomainKey-Status: bad X-DomainKeys: Ecelerity dk_validate implementing draft-delany-domainkeys-base-01 X-PHP-List-Original-Sender: tyra3l@gmail.com X-Host-Fingerprint: 209.85.215.42 mail-ew0-f42.google.com Received: from [209.85.215.42] ([209.85.215.42:63867] helo=mail-ew0-f42.google.com) by pb1.pair.com (ecelerity 2.1.1.9-wez r(12769M)) with ESMTP id 6D/49-10915-6AE7CBD4 for ; Sat, 30 Apr 2011 17:27:03 -0400 Received: by ewy2 with SMTP id 2so1447111ewy.29 for ; Sat, 30 Apr 2011 14:26:59 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:sender:in-reply-to:references:date :x-google-sender-auth:message-id:subject:from:to:cc:content-type; bh=ToWKd+EX5OWKgefKdYGLBjA+thaqrcgn9NgYQB9Drqk=; b=wWPav8I5rsFWhNw72FGrJXfqTEc6VOraX6z6hN90SY/4mfuPB5uJjK9Cn8JW9l3mqQ PBOdh056OU3yb2WrKS/CFwsvLbrorE+oDf9Lqi8wLovqhtQJZaPQJfer7Dy0E00TTLR7 Vh0cZN2B3W3FR0XIgHLkUBjINp9PTGv/oKDYA= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:sender:in-reply-to:references:date :x-google-sender-auth:message-id:subject:from:to:cc:content-type; b=XUTwBjlpeLhPXKjItNgoGqASYNcbOVJCCQ7jJucVQyQQCGeK3NpwARG92J4pzXdjqs N9xP7yPaReO3fDQuj3S1jqzHWbi1qq7N92bsfpyk+HxV2NFHSfzSEgNcm5wJNosqPipf de9clqRKOXm/kYE++thtsT8DryEKWQZbTnEHQ= MIME-Version: 1.0 Received: by 10.14.11.83 with SMTP id 59mr1160153eew.39.1304198817797; Sat, 30 Apr 2011 14:26:57 -0700 (PDT) Sender: tyra3l@gmail.com Received: by 10.14.127.79 with HTTP; Sat, 30 Apr 2011 14:26:57 -0700 (PDT) In-Reply-To: <1304193525-sup-1492@fewbar.com> References: <4DBC2D1B.10302@lerdorf.com> <4DBC4885.7010209@sugarcrm.com> <4DBC4C9A.2050502@lerdorf.com> <1304193525-sup-1492@fewbar.com> Date: Sat, 30 Apr 2011 23:26:57 +0200 X-Google-Sender-Auth: C3_VCrewPtoB4mLE-s5nuDM_0Go Message-ID: To: Clint Byrum Cc: internals Content-Type: multipart/alternative; boundary=0016364c704640579e04a229735c Subject: Re: [PHP-DEV] Change Request: Make PDO default to not emulate prepared statements for MySQL From: info@tyrael.hu (Ferenc Kovacs) --0016364c704640579e04a229735c Content-Type: text/plain; charset=UTF-8 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 --0016364c704640579e04a229735c--