Re: removing idle connections
От | Gary Doades |
---|---|
Тема | Re: removing idle connections |
Дата | |
Msg-id | 41756F5A.19880.626AF123@localhost обсуждение исходный текст |
Ответ на | Re: removing idle connections (Josh Close <narshe@gmail.com>) |
Список | pgsql-general |
On 19 Oct 2004 at 13:32, Josh Close wrote: > The provider is corelabs. The programmer that wrote the code says he's > closing the connections, but they aren't actually closing. > > Any ideas? Or better yet, do you know of a good postgres .net provider? > Hmm, I've had lots of problems with the Corelabs provider. The open source provider (Npgsql) available on GBorg is a lot better for most things. I reverted to using the ODBC driver for Postgres with the .NET Odbc provider. Works fine. With connection pooling enabled you will see several "idle" connections around waiting to be re-used by a provider connection supplying the same credentials and options as a "disconnected" pooled-but-idle connection. If you connect with a different username/password everytime then this may be a problem, otherwise it is a big performance gain in the disconnected recordset world of .NET. Cheers, Gary.
В списке pgsql-general по дате отправления: