Newsgroups: php.internals Path: news.php.net Xref: news.php.net php.internals:60896 Return-Path: Mailing-List: contact internals-help@lists.php.net; run by ezmlm Delivered-To: mailing list internals@lists.php.net Received: (qmail 7408 invoked from network); 20 Jun 2012 03:17:07 -0000 Received: from unknown (HELO lists.php.net) (127.0.0.1) by localhost with SMTP; 20 Jun 2012 03:17:07 -0000 Authentication-Results: pb1.pair.com smtp.mail=yohgaki@gmail.com; spf=pass; sender-id=pass Authentication-Results: pb1.pair.com header.from=yohgaki@gmail.com; sender-id=pass Received-SPF: pass (pb1.pair.com: domain gmail.com designates 209.85.160.170 as permitted sender) X-PHP-List-Original-Sender: yohgaki@gmail.com X-Host-Fingerprint: 209.85.160.170 mail-gh0-f170.google.com Received: from [209.85.160.170] ([209.85.160.170:32783] helo=mail-gh0-f170.google.com) by pb1.pair.com (ecelerity 2.1.1.9-wez r(12769M)) with ESMTP id 7B/B0-00136-1B041EF4 for ; Tue, 19 Jun 2012 23:17:05 -0400 Received: by mail-gh0-f170.google.com with SMTP id g2so5982339ghb.29 for ; Tue, 19 Jun 2012 20:17:05 -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=6hpb+9TRnYiFECfiibkktco7CSkraqoke48QEwpJf1g=; b=FSy29EQzAgP5nwMLnD9WJk09y6KZuFmGmTpaCcy0UXgBcg2SxFswte9c8dEXi0FUGL 3sLFtr9R7BEtFLJrT9E3QReBclB6ZSKRGrcMBIxlRlDfaLdvAji41SJMVgv/1ZHuYAHs 6sQaRoqBSFljYoh9c8yQA/EjEZSoI/6LDyZSHubR1CyuFVvjg5eM9x+105MBMwq7rq6D K0ckhGqpPXqIF9Kq4nWwpSU1Gznycza3BSJ9fDvjIqHzVH8b/dyGVtsca0Ain8sy7XMm fslVEMaCWMBVkkNFEmDiIWu9FDl4Okg1OPJ5O0iAy6fmmZ5Fwc0vXBhm5p+ue8uUOtXJ gtQA== Received: by 10.236.153.8 with SMTP id e8mr26097415yhk.80.1340162224802; Tue, 19 Jun 2012 20:17:04 -0700 (PDT) MIME-Version: 1.0 Sender: yohgaki@gmail.com Received: by 10.147.50.1 with HTTP; Tue, 19 Jun 2012 20:16:24 -0700 (PDT) In-Reply-To: References: Date: Wed, 20 Jun 2012 12:16:24 +0900 X-Google-Sender-Auth: J6gA7XYWdrrJqcPXJa53wGcsS1k Message-ID: To: Anthony Ferrara Cc: 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, I'm not opposed to this change, but I would like to give some ideas. If I use PDO postgresql and prepared statement, it executes native prepared query. However, prepared statement is released(removed) when PDOStatement object is destroyed. If PDO MySQL made like this, performance will not increase much unless app issues the same SQL query over and over during request. It would be nice to have option for not to release prepared query for better performance. BTW, PDO should have method for setting client/database encoding. Regards, -- Yasuo Ohgaki yohgaki@ohgaki.net 2012/6/15 Anthony Ferrara : > Hello all, > > I raised this topic on list over a year ago ( > http://marc.info/?l=php-internals&m=130417646507744&w=2 ). It was > determined that it wasn't time yet to disable prepared statement > emulation for MySQL yet. However, Rasmus did mention that it was a > possibility for 5.4 ( > http://marc.info/?l=php-internals&m=130418875017027&w=2 ). Since that > ship has sailed, I submitted a pull request for trunk to change the > default value of prepared statement emulation for MySQL. > > https://github.com/php/php-src/pull/108 > > https://bugs.php.net/bug.php?id=54638 > > Does this need to be an RFC (should I draft one)? Or can it just be > pulled as-is? > > Thanks, > > Anthony > > -- > PHP Internals - PHP Runtime Development Mailing List > To unsubscribe, visit: http://www.php.net/unsub.php >