Re: BLOB performance test FYI - Mailing list pgsql-jdbc

From Anders Bengtsson
Subject Re: BLOB performance test FYI
Date
Msg-id 1019219950.1822.5.camel@spinoza
Whole thread Raw
In response to Re: BLOB performance test FYI  (Barry Lind <barry@xythos.com>)
List pgsql-jdbc
On 2002-04-18 Barry Lind wrote:

> This is a great idea.  This would certainly solve the memory problem for
> inserts.  Selects on the other hand wouldn't be helped since you need to
> read the entire value first before you can get to the rest of the values.

(my second reply to the same message)

I just found this in the JDBC specification:

"For maximum portability, columns within a row should be read in
left-to-right order, and each column should only be read once. This
reflects implementation limitations in some underlying database
protocols."

This means that it would be possible to stream responses too, even with
the current protocol. But it's very impractical for the user, so it's
not a very good solution.

--

A n d e r s  B e n g t s s o n  |  ndrsbngtssn@yahoo.se
Stockholm, Sweden               |


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


pgsql-jdbc by date:

Previous
From: Anders Bengtsson
Date:
Subject: Re: BLOB performance test FYI
Next
From: "Marin Dimitrov"
Date:
Subject: Re: BLOB performance test FYI