Newsgroups: php.internals Path: news.php.net Xref: news.php.net php.internals:52108 Return-Path: Mailing-List: contact internals-help@lists.php.net; run by ezmlm Delivered-To: mailing list internals@lists.php.net Received: (qmail 18532 invoked from network); 30 Apr 2011 17:53:36 -0000 Received: from unknown (HELO lists.php.net) (127.0.0.1) by localhost with SMTP; 30 Apr 2011 17:53:36 -0000 Authentication-Results: pb1.pair.com header.from=rasmus@lerdorf.com; sender-id=unknown Authentication-Results: pb1.pair.com smtp.mail=rasmus@lerdorf.com; spf=permerror; sender-id=unknown Received-SPF: error (pb1.pair.com: domain lerdorf.com from 209.85.210.42 cause and error) X-PHP-List-Original-Sender: rasmus@lerdorf.com X-Host-Fingerprint: 209.85.210.42 mail-pz0-f42.google.com Received: from [209.85.210.42] ([209.85.210.42:58259] helo=mail-pz0-f42.google.com) by pb1.pair.com (ecelerity 2.1.1.9-wez r(12769M)) with ESMTP id E9/52-10915-F9C4CBD4 for ; Sat, 30 Apr 2011 13:53:36 -0400 Received: by pzk37 with SMTP id 37so2756077pzk.29 for ; Sat, 30 Apr 2011 10:53:32 -0700 (PDT) Received: by 10.142.209.20 with SMTP id h20mr213414wfg.319.1304186012337; Sat, 30 Apr 2011 10:53:32 -0700 (PDT) Received: from [192.168.200.140] (c-76-126-236-132.hsd1.ca.comcast.net [76.126.236.132]) by mx.google.com with ESMTPS id k7sm4758049wfa.14.2011.04.30.10.53.31 (version=TLSv1/SSLv3 cipher=OTHER); Sat, 30 Apr 2011 10:53:31 -0700 (PDT) Message-ID: <4DBC4C9A.2050502@lerdorf.com> Date: Sat, 30 Apr 2011 10:53:30 -0700 User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.2.15) Gecko/20110419 Thunderbird/3.1.9 MIME-Version: 1.0 To: Stas Malyshev CC: Anthony Ferrara , "internals@lists.php.net" References: <4DBC2D1B.10302@lerdorf.com> <4DBC4885.7010209@sugarcrm.com> In-Reply-To: <4DBC4885.7010209@sugarcrm.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Subject: Re: [PHP-DEV] Change Request: Make PDO default to not emulate prepared statements for MySQL From: rasmus@lerdorf.com (Rasmus Lerdorf) 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. -R