Re: pgsql: Binary data support improvement
| From: | Matteo Beccati | Date: | Tue, 02 Jul 2013 11:03:29 +0000 |
| Subject: | Re: pgsql: Binary data support improvement | ||
| References: | 1 2 3 4 5 6 7 | Groups: | php.internals |
| Request: | Send a blank email to internals+get-68036@lists.php.net to get a copy of this message | ||
On 02/07/2013 12:52, Yasuo Ohgaki wrote:
> Hi Matteo,
>
> 2013/7/2 Matteo Beccati <php@beccati.com <F[9B
> mailto:php@beccati.com>>
>>
>> > 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/