Re: Enabling connection pooling by default

Поиск
Список
Период
Сортировка
Искать
От
Andrus
Тема
Re: Enabling connection pooling by default
Дата
Msg-id
A8D0269B3A984E679C31D6C970857474@andrusnotebook
Ответ на
Список
Дерево обсуждения
Enabling connection pooling by default "Andrus" <kobruleht2@hot.ee>
Re: Enabling connection pooling by default "Richard Broersma" <richard.broersma@gmail.com>
Re: Enabling connection pooling by default "Andrus" <kobruleht2@hot.ee>
Re: Enabling connection pooling by default Andrei Kovalevski <andyk@commandprompt.com>
Re: Enabling connection pooling by default "Andrus" <kobruleht2@hot.ee>
Re: Enabling connection pooling by default "Richard Broersma" <richard.broersma@gmail.com>
Re: Enabling connection pooling by default "Andrus" <kobruleht2@hot.ee>
Re: Enabling connection pooling by default "Richard Broersma" <richard.broersma@gmail.com>
Re: Enabling connection pooling by default "Andrus" <kobruleht2@hot.ee>
Re: Enabling connection pooling by default "Adam M" <gnuman1@gmail.com>
Re: Enabling connection pooling by default "Andrus" <kobruleht2@hot.ee>
Re: Enabling connection pooling by default Craig Ringer <craig@postnewspapers.com.au>
Re: Enabling connection pooling by default "Andrus" <kobruleht2@hot.ee>
Re: Enabling connection pooling by default Andrei Kovalevski <andyk@commandprompt.com>
Re: Enabling connection pooling by default "Jonah H. Harris" <jonah.harris@gmail.com>
Thank you.

So the program flow should be

1. Read registry key 
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PostgreSQL Unicode\CPTimeout
2. It it does not exists or is zero, application requires registry write 
access and wrote this key with value 60

Is this best solution ?
Or is there some ODBC api function which can used for this ?

I'm bit confused by the fact that pooling is not turned on by default.
So almost every PostgreSQL ODBC application does not use pooling.

Is connection pooling tested and works OK with unicode driver ?
Can pooling turned on by default in next driver release ?

Andrus.

----- Original Message ----- 

> I have discovered this problem a little. It seems to me installer has to 
> set "CPTimeout" registry key  to some integer value. This will enable 
> pooling by default. Here is this registry key:
>
> HKEY_LOCAL_MACHINE\Software\Odbc\Odbcinst.ini\ODBC_driver_name\CPTimeout 

В списке pgsql-odbc по дате отправления
От: Andrei Kovalevski
Дата:
От: Richard Broersma
Дата:
FAQ