|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
November 28th, 2001, 11:46 PM
|
|||
|
|||
|
Connection Pooling of Database in JSP
Hi,
I am working on a tool with JSP front end, and MS Access as the database.... there are 12 JSPs... and each of them functionally do similar things... connect to the same database, access data, show it, and then disconnect from the Database. However, i find that since each page individually connects to the database and then at the end disconnects, the performance can be improved by connecting just once, and maintaining the connection throughout the session... and disconnecting from the database at the time of invalidating the session. Is there some way this can be achieved > 
|
|
#2
November 30th, 2001, 03:01 AM
|
||||
|
||||
Poolman
yes!
Poolman ( http://www.codestudio.com/ ) or others are the solution. Could you please report on your experience, if you happen to use it?
__________________
My blog about OpenSource Databases PDF tutorials about OSS databases, DBMonster ... Please contribute to Open Source Development, fill bug reports!!! Developer Shed eSupport Commented my.ini/my.cnf (PLEASE ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins
|
|
#3
January 4th, 2002, 05:28 AM
|
|||
|
|||
Re: Poolman
I havent yet tried out PoolMan... But thanks a million for the tip
 I will try it out... and let you know... for the timebeing it seems to be the solution. And one more thing, the no. of JSPs have gone up from 12 to 344 and the RDBMS now is Oracle 8i containing 3445 MB of data in compressed form. Now the problem is getting more and more severe. Also since there are more than 200 users logging in every hour or so, performance tuning has become mandatory !! Ciao. 
|
|
| Viewing: Dev Shed Forums > Programming Languages > Java Help > Connection Pooling of Database in JSP |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
