Newsgroups: php.internals Path: news.php.net Xref: news.php.net php.internals:52110 Return-Path: Mailing-List: contact internals-help@lists.php.net; run by ezmlm Delivered-To: mailing list internals@lists.php.net Received: (qmail 22244 invoked from network); 30 Apr 2011 18:16:13 -0000 Received: from unknown (HELO lists.php.net) (127.0.0.1) by localhost with SMTP; 30 Apr 2011 18:16:13 -0000 Authentication-Results: pb1.pair.com smtp.mail=shadda@gmail.com; spf=pass; sender-id=pass Authentication-Results: pb1.pair.com header.from=shadda@gmail.com; sender-id=pass; domainkeys=bad Received-SPF: pass (pb1.pair.com: domain gmail.com designates 209.85.210.42 as permitted sender) DomainKey-Status: bad X-DomainKeys: Ecelerity dk_validate implementing draft-delany-domainkeys-base-01 X-PHP-List-Original-Sender: shadda@gmail.com X-Host-Fingerprint: 209.85.210.42 mail-pz0-f42.google.com Received: from [209.85.210.42] ([209.85.210.42:53154] helo=mail-pz0-f42.google.com) by pb1.pair.com (ecelerity 2.1.1.9-wez r(12769M)) with ESMTP id 76/F2-10915-CE15CBD4 for ; Sat, 30 Apr 2011 14:16:13 -0400 Received: by pzk37 with SMTP id 37so2760617pzk.29 for ; Sat, 30 Apr 2011 11:16:09 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:subject:mime-version:content-type:from :in-reply-to:date:cc:content-transfer-encoding:message-id:references :to:x-mailer; bh=pQIAOLaMroMu/JC+eeCT+NCcpxzqglHIiarvssVPXlE=; b=W0NgZ6oQEAS/P7kWlyX8fR6BC06GobsGUaotYEVbPqgDQyMXc9P+yyyIQvRwm/9OWW 7MhCM2ifNT4oJrauSvIhBzJUGIHqs8Rc2aoVfLK8gdhuDvCA0nudsj+tpkHsrZXllpsB 3lKypJbS2Z2Ot3hMO14eifc+eThB0W6b64Lx0= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=subject:mime-version:content-type:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to:x-mailer; b=Y53sHR4QzD6HkV5262dRv9f8ipOQgoZr2cCjqbsUUYbAsnYfSdJuKukbrsY1viagv9 HdSFUaVcFw9VsMxnoEKmjjw9zuZuoIvtVv5qyvgKof2XHoj1BoQH4+fCF0OdhkaF0id9 oEt6gm5nF5ge+406YW7qgw4/J117t+CbtP7uo= Received: by 10.68.40.69 with SMTP id v5mr6763297pbk.467.1304187369614; Sat, 30 Apr 2011 11:16:09 -0700 (PDT) Received: from [192.168.1.100] ([98.156.62.98]) by mx.google.com with ESMTPS id y7sm319530pbg.43.2011.04.30.11.16.07 (version=TLSv1/SSLv3 cipher=OTHER); Sat, 30 Apr 2011 11:16:08 -0700 (PDT) Mime-Version: 1.0 (Apple Message framework v1084) Content-Type: text/plain; charset=us-ascii In-Reply-To: Date: Sat, 30 Apr 2011 13:16:03 -0500 Cc: Internals Mailing List Content-Transfer-Encoding: quoted-printable Message-ID: References: <4DBC2D1B.10302@lerdorf.com> <4DBC4885.7010209@sugarcrm.com> <4DBC4C9A.2050502@lerdorf.com> To: Ferenc Kovacs X-Mailer: Apple Mail (2.1084) Subject: Re: [PHP-DEV] Change Request: Make PDO default to not emulate prepared statements for MySQL From: shadda@gmail.com (Matt Wilson) Really would depend on the user. Part of my company still runs on = SQLServer 2003, for instance... Corporate infrastructure rarely sees upgrades. Your cousin with the = wordpress fetish, on the other hand... On Apr 30, 2011, at 1:10 PM, Ferenc Kovacs wrote: > On Sat, Apr 30, 2011 at 7:53 PM, Rasmus Lerdorf = wrote: >=20 >> On 04/30/2011 10:36 AM, Stas Malyshev wrote: >>=20 >>> Hi! >>>=20 >>> 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 >>>>=20 >>>=20 >>> 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. >>>=20 >>=20 >> People upgrade their databases even slower than they upgrade their = PHP. >>=20 >> -R >>=20 >>=20 >>=20 > 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. >=20 > Tyrael