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
