Re: BLOB performance test FYI

Поиск
Список
Период
Сортировка
От Anders Bengtsson
Тема Re: BLOB performance test FYI
Дата
Msg-id 1019219950.1822.5.camel@spinoza
обсуждение исходный текст
Ответ на Re: BLOB performance test FYI  (Barry Lind <barry@xythos.com>)
Список 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 по дате отправления:

Предыдущее
От: Anders Bengtsson
Дата:
Сообщение: Re: BLOB performance test FYI
Следующее
От: "Marin Dimitrov"
Дата:
Сообщение: Re: BLOB performance test FYI