Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Has anyone implemented connection pooling in C# .NET?
On 5/8/06, romyd misc <romydmisc (AT) gmail (DOT) com> wrote:
What i meant by implementing connection pooling i meant if i need to do |
any code changes other than changes in connection string.
On 5/8/06, Tim Lucia <timlucia (AT) yahoo (DOT) com> wrote:
I don't hear "you need to implement connection pooling". Maybe, but I
you might still have errors under load, as you approach the maximum
connection count in the pool.
From: romyd misc [mailto:romydmisc (AT) gmail (DOT) com ]
Sent: Monday, May 08, 2006 2:37 PM
To: mysql (AT) lists (DOT) mysql.com
Subject: Connection Pooling
I'm developing an application using C# .NET and mysql as database. It's
multithreaded application, we open a mysql database connection at the
beginning when the application is started and all the database requests
the same connection. But under stress or when more than one request try
access database, i get "object reference errors". I don't get this erro=
when frequency of database calls is low. Does it sounds like i need to
implement connection pooling?
I tried to lookup online, but couldn't find any help under mysql
documentation. Can someone help me setting up mysql connection pooling
Thanks in advance,