Re: [RFC] How about changing the default value of defaultRowFetchSize?

Поиск
Список
Период
Сортировка
От Tsunakawa, Takayuki
Тема Re: [RFC] How about changing the default value of defaultRowFetchSize?
Дата
Msg-id 0A3221C70F24FB45833433255569204D1F63569F@G01JPEXMBYT05
обсуждение исходный текст
Ответ на Re: [RFC] How about changing the default value of defaultRowFetchSize?  (Dave Cramer <pg@fastcrypt.com>)
Ответы Re: [RFC] How about changing the default value of defaultRowFetchSize?
Re: [RFC] How about changing the default value of defaultRowFetchSize?
Список pgsql-jdbc
From: pgsql-jdbc-owner@postgresql.org
> [mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Dave Cramer
>     ​defaultRowFetchSize is not an internal number.​ If you set the
> property you get the value of the property.
> 
> 
> 
> 
> That I agree with. If you don't set it you get 0

You will get the value of defaultRowFetchSize if you don't call setFetchSize(), and the default value of
defaultRowFetchSizewill be, say, 100.  As I mentioned in the previous mail, I think getFetchSize() returns the actual
numberof rows, not the hint (0).
 

Any comments on the default value of defaultRowFetchSize?  There was a request for 1,000.  I think 100 would be
sufficient,considering the typical web pagination, for example.  Those who want to speed up batch apps by reducing
roundtrips can find the parameter and/or setFetchSize() and use them.
 

Regards
Takayuki Tsunakawa





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

Предыдущее
От: Dave Cramer
Дата:
Сообщение: Re: [RFC] How about changing the default value of defaultRowFetchSize?
Следующее
От: "Tsunakawa, Takayuki"
Дата:
Сообщение: Re: [RFC] How about changing the default value ofdefaultRowFetchSize?