Has anyone implemented connection pooling in C# .NET?
On 5/8/06, romyd misc <romydmisc@stripped> 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@stripped> 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:romydmisc@stripped ]
> > Sent: Monday, May 08, 2006 2:37 PM
> > To: mysql@stripped
> > 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