Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:61015
Return-Path: <rasmus@lerdorf.com>
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Delivered-To: mailing list internals@lists.php.net
Received: (qmail 95883 invoked from network); 28 Jun 2012 03:50:09 -0000
Received: from unknown (HELO lists.php.net) (127.0.0.1)
  by localhost with SMTP; 28 Jun 2012 03:50:09 -0000
Authentication-Results: pb1.pair.com smtp.mail=rasmus@lerdorf.com; spf=permerror; sender-id=unknown
Authentication-Results: pb1.pair.com header.from=rasmus@lerdorf.com; sender-id=unknown
Received-SPF: error (pb1.pair.com: domain lerdorf.com from 209.85.216.182 cause and error)
X-PHP-List-Original-Sender: rasmus@lerdorf.com
X-Host-Fingerprint: 209.85.216.182 mail-qc0-f182.google.com  
Received: from [209.85.216.182] ([209.85.216.182:42792] helo=mail-qc0-f182.google.com)
	by pb1.pair.com (ecelerity 2.1.1.9-wez r(12769M)) with ESMTP
	id 56/34-08168-074DBEF4 for <internals@lists.php.net>; Wed, 27 Jun 2012 23:50:09 -0400
Received: by qcsg15 with SMTP id g15so1058838qcs.13
        for <internals@lists.php.net>; Wed, 27 Jun 2012 20:50:06 -0700 (PDT)
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=google.com; s=20120113;
        h=message-id:date:from:user-agent:mime-version:to:cc:subject
         :references:in-reply-to:x-enigmail-version:content-type
         :content-transfer-encoding:x-gm-message-state;
        bh=Z92TjfCmQE1pFyTN8498n8M/dgdgUHKs2rf+Gzstx34=;
        b=AtCog84MKH4Q/58EVj14C/l//tCn0aWJz+xsguTf97dNyVvaFo3Uzk//4R6e3e6Sw5
         giLlpFc30Sip0XvIqxlSroJILrACn4/8T6owGb2JqtSzFw+nb+LA4fVXir99ffu2VTxD
         Je5+r0DNx8pAZ54sPCItrjWOMSY0p2+yao5a2BFSJ4aud+0DoVDWrWBser58EmjL/cFh
         Ti3EKQR/hMQVGv/EVw1ZVp6ba6LYQv1MSzNPbRp4OCBI1pbNDR6Ba4zcy9N0Cn4PheGq
         2B0KzRN/v5S4P7ZfU5FqT4nmefmb+uUkdfoGhvahjNHUMtaRgZ/OrCtE7zKg0Fj8zXub
         UAtA==
Received: by 10.229.136.82 with SMTP id q18mr110538qct.147.1340855405787;
        Wed, 27 Jun 2012 20:50:05 -0700 (PDT)
Received: from [172.16.26.30] ([38.106.64.245])
        by mx.google.com with ESMTPS id gd2sm1210113qab.18.2012.06.27.20.50.03
        (version=SSLv3 cipher=OTHER);
        Wed, 27 Jun 2012 20:50:04 -0700 (PDT)
Message-ID: <4FEBD46A.4000404@lerdorf.com>
Date: Wed, 27 Jun 2012 20:50:02 -0700
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:13.0) Gecko/20120615 Thunderbird/13.0.1
MIME-Version: 1.0
To: Yasuo Ohgaki <yohgaki@ohgaki.net>
CC: Anthony Ferrara <ircmaxell@gmail.com>, internals@lists.php.net
References: <CAAyV7nFciZcsL+AW9W4GbhM+PhM3RhWOJ7G0iBQsEHfSWO2QmA@mail.gmail.com> <CAGa2bXbXcaMtiFLN+9fhZ=dG4anYPnZgNjVdxoEt2DYPZh=sUQ@mail.gmail.com> <CAGa2bXYY8Q8GTm6q194DvtK7G9-pVTwMwBiEKzgsWsp5z0Wx9w@mail.gmail.com>
In-Reply-To: <CAGa2bXYY8Q8GTm6q194DvtK7G9-pVTwMwBiEKzgsWsp5z0Wx9w@mail.gmail.com>
X-Enigmail-Version: 1.4.2
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Gm-Message-State: ALoCoQnUekp6awhBg1voQaYRyTJhzG/MhyoP1/HltyhyKt7lHI8Li5IwDZNrR67FmSpoex4iVrh9
Subject: Re: [PHP-DEV] [PATCH - PR] Disable ATTR_EMULATE_PREPARES by default
 for PDO_Mysql
From: rasmus@lerdorf.com (Rasmus Lerdorf)

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

-Rasmus