Re: [postgis-devel] JDBC & WKB - 400% overhead

Markus,

>Maybe your postgresql driver only uses text transfer up to now.
>asBinary() returns a byte array, so this should be transferred more
>efficiently.

I'm using the JDBC3 build 310 drivers (latest from jdbc.postgresql.org).

>Can you try the following query:
>
>select 5::float8,asBinary('POINT(0 0)')::bytea
>
asBinary() already returns a bytea:

#\df asbinary
List of functions
Schema | Name | Result data type | Argument data types
--------+----------+------------------+---------------------
public | asbinary | bytea | geometry
public | asbinary | bytea | geometry, text
(2 rows)

But, I tried your query and it, also, sends 84 bytes.

dave

----------------------------------------------------------
This mail sent through IMP: https://webmail.limegroup.com/