Newsgroups: php.internals Path: news.php.net Xref: news.php.net php.internals:52109 Return-Path: Mailing-List: contact internals-help@lists.php.net; run by ezmlm Delivered-To: mailing list internals@lists.php.net Received: (qmail 20846 invoked from network); 30 Apr 2011 18:10:54 -0000 Received: from unknown (HELO lists.php.net) (127.0.0.1) by localhost with SMTP; 30 Apr 2011 18:10:54 -0000 Authentication-Results: pb1.pair.com header.from=tyra3l@gmail.com; sender-id=pass; domainkeys=bad Authentication-Results: pb1.pair.com smtp.mail=tyra3l@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: tyra3l@gmail.com X-Host-Fingerprint: 209.85.215.170 mail-ey0-f170.google.com Received: from [209.85.215.170] ([209.85.215.170:40716] helo=mail-ey0-f170.google.com) by pb1.pair.com (ecelerity 2.1.1.9-wez r(12769M)) with ESMTP id 9B/A2-10915-DA05CBD4 for ; Sat, 30 Apr 2011 14:10:54 -0400 Received: by eyf5 with SMTP id 5so1429321eyf.29 for ; Sat, 30 Apr 2011 11:10:50 -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=V9oITgGSQTTz3giDRQ8P+ICcyc7sPkLnC9OtC8+Pa7A=; b=ki5+RLuElEOf2nhuF9+bI7JJ7iXt64AOsDN5AJAI+eTbU00YUV2+SdJxg91DmhMsFh aR/UFjjCoBw3rsCuceW2RN3jm6vmD5BqZzrr8Yi59/0lT2RT7iEFf3wxHymjvpKCQIhh 04mao6my33evfAlipTIGTE3cWTnKm9QJioxyY= 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=bPG23vwLidzJD0oLGQSFQ5OGgintxl8q4Via9gnMMSH2rhjndfNLPwlwacGuJsqpf7 3XUTy6O1LR19cMJmmCc4nYnWP9zpuxpZ2jIJlMG6413v7CLjEKvI7WZwQCfHEquBOCsX 57ME4OMauxDo0g8Zf0fdLTVZ0bLDD8pp2enig= MIME-Version: 1.0 Received: by 10.14.137.198 with SMTP id y46mr2751326eei.103.1304187049737; Sat, 30 Apr 2011 11:10:49 -0700 (PDT) Sender: tyra3l@gmail.com Received: by 10.14.127.79 with HTTP; Sat, 30 Apr 2011 11:10:49 -0700 (PDT) In-Reply-To: <4DBC4C9A.2050502@lerdorf.com> References: <4DBC2D1B.10302@lerdorf.com> <4DBC4885.7010209@sugarcrm.com> <4DBC4C9A.2050502@lerdorf.com> Date: Sat, 30 Apr 2011 20:10:49 +0200 X-Google-Sender-Auth: 2bx4HUHPANoXPiZ_K9dsy7BLSbk Message-ID: To: Rasmus Lerdorf Cc: Stas Malyshev , Anthony Ferrara , "internals@lists.php.net" Content-Type: multipart/alternative; boundary=20cf30363ac3d1fdc704a226b580 Subject: Re: [PHP-DEV] Change Request: Make PDO default to not emulate prepared statements for MySQL From: info@tyrael.hu (Ferenc Kovacs) --20cf30363ac3d1fdc704a226b580 Content-Type: text/plain; charset=UTF-8 On Sat, Apr 30, 2011 at 7:53 PM, Rasmus Lerdorf wrote: > 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 > > > with 5.0 EOL-ed for some time, and even the debian stable is running 5.1, I wonder how many of our user runs 5.0. Tyrael --20cf30363ac3d1fdc704a226b580--