Re: [postgis-devel] JDBC & WKB - 400% overhead - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: [postgis-devel] JDBC & WKB - 400% overhead
Date
Msg-id Pine.BSO.4.56.0502240455120.17412@leary.csoft.net
Whole thread Raw
In response to Re: [postgis-devel] JDBC & WKB - 400% overhead  (Markus Schaber <schabios@logi-track.com>)
Responses Re: [postgis-devel] JDBC & WKB - 400% overhead  (Markus Schaber <schabios@logi-track.com>)
List pgsql-jdbc

On Thu, 24 Feb 2005, Markus Schaber wrote:

> Oh, I thought that binary transmit was implemented in 8.0 :-(
>

Binary transmission was done for sending bytea data, which was a big win,
but that's something we can do because we know we're sending binary data.

> As there are at least plans to use caching of prepared statements, it
> also should be possible to cache this information together with the
> prepared statement. This would reduce the number of roundtrips.

That's true, this information could be received on the first query or say
a PreparedStatement.getMetaData() call.  This would definitely be a
simpler thing to do, but still 8.1 material I think.


Kris Jurka

pgsql-jdbc by date:

Previous
From: Markus Schaber
Date:
Subject: Re: [postgis-devel] JDBC & WKB - 400% overhead
Next
From: Sergei Georgiev
Date:
Subject: Re: Socket timeouts (probably)