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]

Reply via email to