Wednesday, August 13, 2003 06:00 AM
I dont think that there is any 'maximum # of connections'. This number depends the performance that you need. After a certain number, as the no. of DB coonections increase, the performance of an application keeps degrading. So when we see that the response time for an application is more, we should think of reducing the no. of DB connections(optimization on the DB side).