Re: Patch to add a socketTimeout property.

Поиск
Список
Период
Сортировка
От Toru SHIMOGAKI
Тема Re: Patch to add a socketTimeout property.
Дата
Msg-id e43b8e4f0804111727j535b62e3i4e356295b19b0023@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Patch to add a socketTimeout property.  (Kris Jurka <books@ejurka.com>)
Ответы Re: Patch to add a socketTimeout property.  (Kris Jurka <books@ejurka.com>)
Список pgsql-jdbc
2008/4/11, Kris Jurka <books@ejurka.com>:

>   I don't see a danger with exposing them as options as long as the pros and
> cons are clearly explained.

How about the following list to compare keepalive and socket timeout?
Please add other topics, if any.


                 keepalive                 socket timeout
------------------------------------------------------------------
Configurability  No in Java                Yes
                 (depend on OS setting)

Target           All connections           Each connection

Standard timer   2 hours                   Depend on users
 setting

Influence        All of applications       Long running query
                 on a same OS              using a same connection

Overhead         Network for               CPU for timer
                 keepalive proves



On the other hand, should we  provide the both properties and users
chose either of them depend on their requirement?

--
Toru SHIMOGAKI <shimogaki.toru@gmail.com>

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

Предыдущее
От: Art Gramlich
Дата:
Сообщение: Re: Patch to add a socketTimeout property.
Следующее
От: Stanislav Mironov
Дата:
Сообщение: Two BLOBs (OID) in table?