Newsgroups: php.internals Path: news.php.net Xref: news.php.net php.internals:52103 Return-Path: Mailing-List: contact internals-help@lists.php.net; run by ezmlm Delivered-To: mailing list internals@lists.php.net Received: (qmail 92013 invoked from network); 30 Apr 2011 16:06:40 -0000 Received: from unknown (HELO lists.php.net) (127.0.0.1) by localhost with SMTP; 30 Apr 2011 16:06:40 -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.210.42 cause and error) X-PHP-List-Original-Sender: rasmus@lerdorf.com X-Host-Fingerprint: 209.85.210.42 mail-pz0-f42.google.com Received: from [209.85.210.42] ([209.85.210.42:32884] helo=mail-pz0-f42.google.com) by pb1.pair.com (ecelerity 2.1.1.9-wez r(12769M)) with ESMTP id 5F/6D-10915-E833CBD4 for ; Sat, 30 Apr 2011 12:06:39 -0400 Received: by pzk37 with SMTP id 37so2734585pzk.29 for ; Sat, 30 Apr 2011 09:06:35 -0700 (PDT) Received: by 10.142.2.33 with SMTP id 33mr2285094wfb.232.1304179595708; Sat, 30 Apr 2011 09:06:35 -0700 (PDT) Received: from [192.168.200.140] (c-76-126-236-132.hsd1.ca.comcast.net [76.126.236.132]) by mx.google.com with ESMTPS id j7sm2641218pbg.65.2011.04.30.09.06.34 (version=TLSv1/SSLv3 cipher=OTHER); Sat, 30 Apr 2011 09:06:34 -0700 (PDT) Message-ID: <4DBC3389.9030904@lerdorf.com> Date: Sat, 30 Apr 2011 09:06:33 -0700 User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.2.15) Gecko/20110419 Thunderbird/3.1.9 MIME-Version: 1.0 To: Ferenc Kovacs CC: Anthony Ferrara , internals@lists.php.net References: <4DBC2D1B.10302@lerdorf.com> In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Subject: Re: [PHP-DEV] Change Request: Make PDO default to not emulate prepared statements for MySQL From: rasmus@lerdorf.com (Rasmus Lerdorf) On 04/30/2011 08:45 AM, Ferenc Kovacs wrote: > I disable query_cache on my machines, because it can cause performance > and stability issues. > http://www.mysqlperformanceblog.com/2011/04/10/should-we-give-a-mysqlquery-cache-a-second-chance/ Sure, there are some problems with it, but if you understand how it works and cache the queries that will benefit, it can give you a significant performance boost. -Rasmus