It sounds like you need to either synchronize access to 'the connection' (one user at a time), or have a connection per request. In the latter case, obtaining a connection from a pool of connections makes sense. Unfortunately, I have only done this with Java -- not with .NET. I would be surprised, however, if you had to do anything special, other then connecting via a pooling connection string. In the Java case, connection.close() is overridden to simply return the connection to the pool (and .open() borrows one, ...)
Tim -----Original Message----- From: romyd misc [mailto:[EMAIL PROTECTED] Sent: Monday, May 08, 2006 4:33 PM To: Tim Lucia Cc: mysql@lists.mysql.com Subject: Re: Connection Pooling 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 > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
