Re: new String(byte[]) performance - Mailing list pgsql-jdbc

From Barry Lind
Subject Re: new String(byte[]) performance
Date
Msg-id 3DB58525.9040703@xythos.com
Whole thread Raw
In response to Re: new String(byte[]) performance  (Aaron Mulder <ammulder@alumni.princeton.edu>)
Responses Re: new String(byte[]) performance
List pgsql-jdbc

Aaron Mulder wrote:
> Barry,
>     Are you saying that the server returns everything as
> strings/characters no matter what?  Like if it sends the number "123456"
> that will be 7 bytes (6+null), not 4 bytes (an int)?  Can we make it send
> the 4-byte int value instead?

That is correct.  The FE/BE protocol sends the data back and forth as
strings for all the data types.  The only exception to this is if you
are using a 'binary cursor' inwhich case the data is sent in binary,
(however the byte order is platform dependent, which makes it a pain to
use binary cursors).

--Barry




pgsql-jdbc by date:

Previous
From: Aaron Mulder
Date:
Subject: Re: new String(byte[]) performance
Next
From: Teofilis Martisius
Date:
Subject: Re: new String(byte[]) performance