Re: not fetching all query results

Поиск
Список
Период
Сортировка
От Dave Cramer
Тема Re: not fetching all query results
Дата
Msg-id CADK3HH+HEot-uX0Vd23dN0nQW8Nrp2+E6gTFVN9TvLWHW7-cLw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: not fetching all query results  (Dave Cramer <pg@fastcrypt.com>)
Ответы Re: not fetching all query results  (Radim Kolar <hsn@filez.com>)
Список pgsql-jdbc
Further more the spec actually says the default is 0

Gives the JDBC driver a hint as to the number of rows that should be
fetched from the database when more rows are needed for ResultSet
objects genrated by this Statement. If the value specified is zero,
then the hint is ignored. The default value is zero.


dave.cramer(at)credativ(dot)ca
http://www.credativ.ca


On Tue, Jul 17, 2012 at 2:28 PM, Dave Cramer <pg@fastcrypt.com> wrote:
> Well the default is 0 which means that it is off, if you want to
> activate it then set it to something.
>
> Dave Cramer
>
> dave.cramer(at)credativ(dot)ca
> http://www.credativ.ca
>
>
> On Tue, Jul 17, 2012 at 2:14 PM, Radim Kolar <hsn@filez.com> wrote:
>>
>> setFetchSize is defined there:
>>
>> https://github.com/pgjdbc/pgjdbc/blob/master/org/postgresql/jdbc2/AbstractJdbc2Statement.java
>>
>> but i havent checked if this value is really used for something. But
>> probably not because its OOM here if result set is over 30k rows.
>>
>>
>> --
>> Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-jdbc

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Dave Cramer
Дата:
Сообщение: Re: not fetching all query results
Следующее
От: Radim Kolar
Дата:
Сообщение: Re: not fetching all query results