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

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

From
dblasby@openplans.org
Date:
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/