[EMAIL PROTECTED] wrote:
DatabaseRegistry.loadDatabase() takes long time to load the database when more than 30 concurrent transaction are created each from a different JVM. As the number concurrent transaction increases the time taken to load database also increases.
The System configuration is:
processor model name : Intel(R) Xeon(TM) CPU 2.40GHz
MemTotal: 4012816 kB
Platform : Red Hat Linux (2.4.19)
MySQL database 4.0.17
Thanks,
Banujee
Banujee,
It appears that you're loading a new database for each transaction. Is this correct?! If so, this is *highly* unrecommended. I *highly* recommend that you look into database connection pooling via DBCP or PoolMan.
The creation of JDBC Connection objects consumes a large amount of overhead and should never take place over and over again. By utilizing database connection pooling a pool of Connection objects is created and these connections are used over and over again and minded by the pool.
Bruce
--
perl -e 'print unpack("u30","<0G)[EMAIL PROTECTED]&5R\\"F9E<G)E=\\$\\!F<FEI+F-O;0\\`\\`");'
The Castor Project http://www.castor.org/
Apache Geronimo http://incubator.apache.org/projects/geronimo.html
----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-user
