Re: Status of binary protocol usage?
- From: aaime74 <andrea(dot)aime(at)gmail(dot)com>
- To: pgsql-jdbc(at)postgresql(dot)org
- Subject: Re: Status of binary protocol usage?
- Date: Sun, 24 Jun 2007 09:21:56 -0700 (PDT)
- Message-id: <11276153.post@talk.nabble.com> <text/plain>
Tom Lane-2 wrote:
>
> aaime74 <andrea(dot)aime(at)gmail(dot)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.
Home |
Main Index |
Thread Index