Re: Status of binary protocol usage? - Mailing list pgsql-jdbc

From aaime74
Subject Re: Status of binary protocol usage?
Date
Msg-id 11276153.post@talk.nabble.com
Whole thread Raw
In response to Re: Status of binary protocol usage?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Status of binary protocol usage?
List pgsql-jdbc


Tom Lane-2 wrote:
>
> aaime74 <andrea.aime@gmail.com> writes:
>> A profiler informs me that quite a big of time is spent in the
>> PGBytea.toBytes(byte[]s) method, which is used only if the transfer
>> occurrs in text mode.
>
> That hardly seems like a killer argument for switching to binary
> (which has got a boatload of disadvantages of its own).  Surely a
> bit of code-optimization work can fix that.
>

Hum, interesting. What would be the boatload of disadvantages? Is there
any reference to those?
Do you have any idea why doing more processing (Base64 encoding/decoding)
leads to significant better performance? :)

Cheers
Andrea

--
View this message in context: http://www.nabble.com/Status-of-binary-protocol-usage--tf3972236.html#a11276153
Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com.


pgsql-jdbc by date:

Previous
From: Tom Lane
Date:
Subject: Re: Status of binary protocol usage?
Next
From: Russell Francis
Date:
Subject: Patch to improve Cloneable implementation on classes which extend PGobject.