Performance issue with JTS 6.0.3 with WAS Liberty Profile
Hello All,
One answer
WAS liberty is a good choice.
You must however have an understanding of deployment topologies, sizing and databases to use for production.
Check https://jazz.net/wiki/bin/view/Deployment/DeploymentPlanningAndDesign you probably want to avoid putting everything from your list above on one machine. Derby is only for demo purposes.
Comments
In my experience, the embedded Derby is to blame. When using the embedded Derby, the Liberty Java process also act as a database manager, and it just does not do well when running for a long time. With the purchase of CLM, you are entitled to use DB2 so it should be the first choice if there are no particular reasons not to use it.
1 vote
Based on personal experience, I concur with Donald. The Derby database is simply inadequate to the demands. DB2 and SQL Server have both provided substantial performance improvements.
Though I don't recommend the following as a 'fix' for Derby (as Ralph says - that is for DEMO usage only) - you might want to try reducing the default timeout settings listed for Derby in the server.startup file. They are currently very long (almost 20 minutes)..refer to the following (numbers are in seconds):
set JAVA_OPTS=%JAVA_OPTS% -Dderby.locks.waitTimeout=1200
set JAVA_OPTS=%JAVA_OPTS% -Dderby.locks.deadlockTimeout=1140
P.S. The deadlockTimeout MUST BE less than the waitTimeout
P.P.S. - Another concern is the amount of RAM you have on your server machine. The default settings (4G) are simply too low if you installed the reporting applications (LQE alone is a major memory hog). Ralph provided a link describing the system sizing considerations. Your requirements will vary but in my world I would not want to try running even a small team on an All-In-One server that has less than 32G Ram and 8 cores