Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:78125
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 72937 invoked from network); 17 Oct 2014 04:44:13 -0000
Received: from unknown (HELO lists.php.net) (127.0.0.1)
  by localhost with SMTP; 17 Oct 2014 04:44:13 -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.192.52 cause and error)
X-PHP-List-Original-Sender: rasmus@lerdorf.com
X-Host-Fingerprint: 209.85.192.52 mail-qg0-f52.google.com  
Received: from [209.85.192.52] ([209.85.192.52:63668] helo=mail-qg0-f52.google.com)
	by pb1.pair.com (ecelerity 2.1.1.9-wez r(12769M)) with ESMTP
	id F7/C4-41372-C9E90445 for <internals@lists.php.net>; Fri, 17 Oct 2014 00:44:13 -0400
Received: by mail-qg0-f52.google.com with SMTP id q108so31539qgd.39
        for <internals@lists.php.net>; Thu, 16 Oct 2014 21:44:09 -0700 (PDT)
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20130820;
        h=x-gm-message-state:message-id:date:from:user-agent:mime-version:to
         :cc:subject:references:in-reply-to:content-type
         :content-transfer-encoding;
        bh=9HHCbX7ZIgpqz9L/FrZYWEbf3mFVGHd9T11PcQjs6HY=;
        b=kbVxLN0yi07aUS2ODJ7nZL3fCxdxPyhpUMPAHltc+oT1uVaXTWVyPS0X/S8gs3H7UY
         IRO6ipGkjVGdHY9Mtw6MWynzTe2WdYkPdRN7qDfet3RAgU7c5c2RMNbIoL0YCXZFWaZm
         leletN2/c8xNb8Mj+xAg3Fd8kMX5L7BRAbH2oBMP286Y76fQSZp8dMezoXcxiNFsdyY2
         QnSrhyc0tVz33ki4+cyxs5FRyf5CAAOKt8AjCai4vHSXhZZTvIo7S5vzH9n/Eb7MfXwx
         M5x3hEJv6aV6dFnknopAqd3fti5wb1jPj8RHUoFp6b/5xmwp/+4QPuLwkib1sLCfiSGF
         Q+PA==
X-Gm-Message-State: ALoCoQn6YTzTDQPBzoG7YO0JxT1edj7512n41qiMglaSKJD5dqCe2pZAJMFSN7FXGxCZnC8Qo9el
X-Received: by 10.140.29.101 with SMTP id a92mr6425219qga.41.1413521049341;
        Thu, 16 Oct 2014 21:44:09 -0700 (PDT)
Received: from [192.168.200.14] (c-50-131-44-225.hsd1.ca.comcast.net. [50.131.44.225])
        by mx.google.com with ESMTPSA id a97sm197235qge.13.2014.10.16.21.44.08
        for <multiple recipients>
        (version=TLSv1.2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128);
        Thu, 16 Oct 2014 21:44:08 -0700 (PDT)
Message-ID: <54409E97.6070603@lerdorf.com>
Date: Thu, 16 Oct 2014 21:44:07 -0700
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:31.0) Gecko/20100101 Thunderbird/31.2.0
MIME-Version: 1.0
To: Morgan Tocker <morgan.tocker@oracle.com>, 
 christopher jones <christopher.jones@oracle.com>
CC: PHP Internals <internals@lists.php.net>
References: <CAAyV7nFciZcsL+AW9W4GbhM+PhM3RhWOJ7G0iBQsEHfSWO2QmA@mail.gmail.com> <CAH-PCH6jVcXNtyySeY4EJZt2sQqhXFV=acO_x3HJb2f7WKtMPQ@mail.gmail.com> <543FE883.2070401@lerdorf.com> <54400765.90802@oracle.com> <810122F5-99FD-4070-AD98-DCC1FB80B4A8@oracle.com> <64442A85-5B11-456E-928A-F06C95FC0978@oracle.com>
In-Reply-To: <64442A85-5B11-456E-928A-F06C95FC0978@oracle.com>
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
Subject: Re: [PHP-DEV] [PATCH - PR] Disable ATTR_EMULATE_PREPARES by default
 for PDO_Mysql
From: rasmus@lerdorf.com (Rasmus Lerdorf)

On 10/16/2014 02:38 PM, Morgan Tocker wrote:

> The more clear cases would be:
> - The prepared statement is reused enough times that the initial extra round trip can be amortized.
> - If large place-holder values can be sent direct to the server without having to be escaped or parsed.  For example reading a file directly into the contents of a column to insert.

Other than large batch backfill jobs it is not very common to issue the
same query enough times to overcome the connection overhead. At least
not in code I have worked with. But I am glad to see that there is work
being done on it.

-Rasmus