Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:61020
Return-Path: <yohgaki@gmail.com>
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Delivered-To: mailing list internals@lists.php.net
Received: (qmail 25960 invoked from network); 28 Jun 2012 09:55:58 -0000
Received: from unknown (HELO lists.php.net) (127.0.0.1)
  by localhost with SMTP; 28 Jun 2012 09:55:58 -0000
Authentication-Results: pb1.pair.com header.from=yohgaki@gmail.com; sender-id=pass
Authentication-Results: pb1.pair.com smtp.mail=yohgaki@gmail.com; spf=pass; sender-id=pass
Received-SPF: pass (pb1.pair.com: domain gmail.com designates 209.85.213.170 as permitted sender)
X-PHP-List-Original-Sender: yohgaki@gmail.com
X-Host-Fingerprint: 209.85.213.170 mail-yx0-f170.google.com  
Received: from [209.85.213.170] ([209.85.213.170:63356] helo=mail-yx0-f170.google.com)
	by pb1.pair.com (ecelerity 2.1.1.9-wez r(12769M)) with ESMTP
	id E3/09-08168-C2A2CEF4 for <internals@lists.php.net>; Thu, 28 Jun 2012 05:55:57 -0400
Received: by yenl12 with SMTP id l12so1956375yen.29
        for <internals@lists.php.net>; Thu, 28 Jun 2012 02:55:53 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20120113;
        h=mime-version:sender:in-reply-to:references:from:date
         :x-google-sender-auth:message-id:subject:to:cc:content-type;
        bh=0ViVQ49DqYBgfGkuAvyI3hAJoPsurSln6g3WpQD96TQ=;
        b=OD8Fa5UNxat1EvYGKtACrAC54Ta6ff0hZlWakVKH1SKhV9NceRhkiM8yTmN6NXfomp
         0q89IB3iXAxFhk1egkbnU66+8R/4AGj6oyTplh6WdQbHfPO89Y9TA2hBBzmMT9ZRGbvG
         oeWyp6NMJiKMDj2+AabNtwrmtWM377Yrt08FHvlPanoQyFY9SW4GJjGWIdyy+dkCucpq
         XpwIrE/WDWIJQTjk5yLpfVwZn3CMclb/tRszmeduc+v9CxB4Z6iwzKhO9jkeNrG8ntQR
         VF07aeuxGStF4hRcfd6C9fbgkcsfj1Vbztm3uL7JHG3S2ddCl0LKQ8RH4pCf3doz7y7J
         zg0g==
Received: by 10.236.153.8 with SMTP id e8mr2064891yhk.80.1340877353500; Thu,
 28 Jun 2012 02:55:53 -0700 (PDT)
MIME-Version: 1.0
Sender: yohgaki@gmail.com
Received: by 10.147.50.1 with HTTP; Thu, 28 Jun 2012 02:55:10 -0700 (PDT)
In-Reply-To: <4FEBD46A.4000404@lerdorf.com>
References: <CAAyV7nFciZcsL+AW9W4GbhM+PhM3RhWOJ7G0iBQsEHfSWO2QmA@mail.gmail.com>
 <CAGa2bXbXcaMtiFLN+9fhZ=dG4anYPnZgNjVdxoEt2DYPZh=sUQ@mail.gmail.com>
 <CAGa2bXYY8Q8GTm6q194DvtK7G9-pVTwMwBiEKzgsWsp5z0Wx9w@mail.gmail.com> <4FEBD46A.4000404@lerdorf.com>
Date: Thu, 28 Jun 2012 18:55:10 +0900
X-Google-Sender-Auth: gse9ZROvvvPkQHC8jvr5apTEGeU
Message-ID: <CAGa2bXZpPTfxHGE0U_fEUJrFRznMgakakSsEX4Lp-uTRFq46Hg@mail.gmail.com>
To: Rasmus Lerdorf <rasmus@lerdorf.com>
Cc: Anthony Ferrara <ircmaxell@gmail.com>, internals@lists.php.net
Content-Type: text/plain; charset=ISO-8859-1
Subject: Re: [PHP-DEV] [PATCH - PR] Disable ATTR_EMULATE_PREPARES by default
 for PDO_Mysql
From: yohgaki@ohgaki.net (Yasuo Ohgaki)

Hi,

2012/6/28 Rasmus Lerdorf <rasmus@lerdorf.com>:
> On 06/27/2012 08:45 PM, Yasuo Ohgaki wrote:
>> Hi,
>>
>> I forgot to mention MySQL's query cache.
>> This change may have negative performance impact, since prepared
>> query is not cached and native prepared query may not be used by
>> other requests.
>
> That's not really true anymore. There are some limitations, yes, but in
> general prepared statements are cached since MySQL version 5.1.21

Good to know!
Thank you.

--
Yasuo Ohgaki