Has anyone implemented connection pooling in C# .NET?
On 5/8/06, romyd misc <[EMAIL PROTECTED]> wrote:
What i meant by implementing connection pooling i meant if i need to do any code changes other than changes in connection string. Thanks, Romy On 5/8/06, Tim Lucia <[EMAIL PROTECTED]> wrote: > > I don't hear "you need to implement connection pooling". Maybe, but I > think > you might still have errors under load, as you approach the maximum > connection count in the pool. > > Tim > > > -----Original Message----- > From: romyd misc [mailto:[EMAIL PROTECTED] ] > Sent: Monday, May 08, 2006 2:37 PM > To: mysql@lists.mysql.com > Subject: Connection Pooling > > Hi Everyone, > > I'm developing an application using C# .NET and mysql as database. It's > a > multithreaded application, we open a mysql database connection at the > very > beginning when the application is started and all the database requests > use > the same connection. But under stress or when more than one request try > to > access database, i get "object reference errors". I don't get this error > > 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 > with > C#.NET. > > Thanks in advance, > Romy > >
