Newsgroups: php.internals Path: news.php.net Xref: news.php.net php.internals:52107 Return-Path: Mailing-List: contact internals-help@lists.php.net; run by ezmlm Delivered-To: mailing list internals@lists.php.net Received: (qmail 16261 invoked from network); 30 Apr 2011 17:36:10 -0000 Received: from unknown (HELO lists.php.net) (127.0.0.1) by localhost with SMTP; 30 Apr 2011 17:36:10 -0000 Authentication-Results: pb1.pair.com smtp.mail=smalyshev@sugarcrm.com; spf=pass; sender-id=pass Authentication-Results: pb1.pair.com header.from=smalyshev@sugarcrm.com; sender-id=pass Received-SPF: pass (pb1.pair.com: domain sugarcrm.com designates 67.192.241.193 as permitted sender) X-PHP-List-Original-Sender: smalyshev@sugarcrm.com X-Host-Fingerprint: 67.192.241.193 smtp193.dfw.emailsrvr.com Linux 2.6 Received: from [67.192.241.193] ([67.192.241.193:55513] helo=smtp193.dfw.emailsrvr.com) by pb1.pair.com (ecelerity 2.1.1.9-wez r(12769M)) with ESMTP id D9/02-10915-8884CBD4 for ; Sat, 30 Apr 2011 13:36:10 -0400 Received: from localhost (localhost.localdomain [127.0.0.1]) by smtp9.relay.dfw1a.emailsrvr.com (SMTP Server) with ESMTP id 503E73C01B7; Sat, 30 Apr 2011 13:36:06 -0400 (EDT) X-Virus-Scanned: OK Received: by smtp9.relay.dfw1a.emailsrvr.com (Authenticated sender: smalyshev-AT-sugarcrm.com) with ESMTPSA id A21EA3C0198; Sat, 30 Apr 2011 13:36:05 -0400 (EDT) Message-ID: <4DBC4885.7010209@sugarcrm.com> Date: Sat, 30 Apr 2011 12:36:05 -0500 Organization: SugarCRM User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en-US; rv:1.9.2.15) Gecko/20110303 Thunderbird/3.1.9 MIME-Version: 1.0 To: Rasmus Lerdorf CC: Anthony Ferrara , "internals@lists.php.net" References: <4DBC2D1B.10302@lerdorf.com> In-Reply-To: <4DBC2D1B.10302@lerdorf.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: smalyshev@sugarcrm.com (Stas Malyshev) 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. -- Stanislav Malyshev, Software Architect SugarCRM: http://www.sugarcrm.com/ (408)454-6900 ext. 227