I would like to know best Configuration to be give for huge DataBase depended Application. Currently using Websphere we have provided following: Minimum--1 Max--100 Connection Time Out- 300 sec Ilde Time oUt --180 and Orphan Time Out --60. Is this is ok. Because I ahve heard even max connection at 10 Connection Pooling works perfectly. Or pofblem is Moment it reaches Max it stars hanging !!! Pls comment Regards
This is a complicated issue. However, the big picture is we need to adjust the queues in WebSphere Application Server. There is a concept called upstream queuing. The size of Web Server pool, Web container pool, orb thread pool, and datasource pool should decrease sequentially. As far as Connection pool is concerned, Resource analyzer should be used. You need to do some testing.
Jun Hong<br />SCJP, SCJD, SCWCD, SCEA<br />IBM Certified Systems Expert(V4.0)