Newsgroups: php.internals Path: news.php.net Xref: news.php.net php.internals:68036 Return-Path: Mailing-List: contact internals-help@lists.php.net; run by ezmlm Delivered-To: mailing list internals@lists.php.net Received: (qmail 67630 invoked from network); 2 Jul 2013 11:04:08 -0000 Received: from unknown (HELO lists.php.net) (127.0.0.1) by localhost with SMTP; 2 Jul 2013 11:04:08 -0000 Authentication-Results: pb1.pair.com smtp.mail=php@beccati.com; spf=pass; sender-id=pass Authentication-Results: pb1.pair.com header.from=php@beccati.com; sender-id=pass Received-SPF: pass (pb1.pair.com: domain beccati.com designates 176.9.114.167 as permitted sender) X-PHP-List-Original-Sender: php@beccati.com X-Host-Fingerprint: 176.9.114.167 spritz.beccati.com Received: from [176.9.114.167] ([176.9.114.167:38322] helo=mail.beccati.com) by pb1.pair.com (ecelerity 2.1.1.9-wez r(12769M)) with ESMTP id 61/F2-49923-7A3B2D15 for ; Tue, 02 Jul 2013 07:04:07 -0400 Received: (qmail 22971 invoked from network); 2 Jul 2013 11:04:02 -0000 Received: from home.beccati.com (HELO ?192.168.1.202?) (88.149.176.119) by mail.beccati.com with SMTP; 2 Jul 2013 11:04:02 -0000 Message-ID: <51D2B381.2080602@beccati.com> Date: Tue, 02 Jul 2013 13:03:29 +0200 User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/20130509 Thunderbird/17.0.6 MIME-Version: 1.0 To: Yasuo Ohgaki CC: "internals@lists.php.net" References: <51CAB115.60602@beccati.com> <51D29355.9040807@beccati.com> <51D2AC78.3040206@beccati.com> In-Reply-To: Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Subject: Re: [PHP-DEV] pgsql: Binary data support improvement From: php@beccati.com (Matteo Beccati) On 02/07/2013 12:52, Yasuo Ohgaki wrote: > Hi Matteo, > > 2013/7/2 Matteo Beccati > >> >> > The API is not for ease of use, but for better performance as it > eliminate >> > needless hex conversions on both server and client side. >> >> What I meant is that we might have that speed improvements for free in >> PDO when bytea is used as a parameter (i.e. most likely insert/updates). >> With no visible change for the user and full backwards compatibility. > > > libpq's query API only has flag that returns all result as binary or text. I'm talking about parameters, not results. The speedup would be only for inserts, not selects (which would require something that's not available in libpq). Cheers -- Matteo Beccati Development & Consulting - http://www.beccati.com/