[opencms-dev] Max Connectionsl/Performance Problem

[Simon Wilks]

Hi all,

I am having a problem with performance with DB2 at the moment and one of the
things I have noticed is that the speed with which OpenCms runs depends on
the value of the resourcebroker.mySql.maxConn parameter in the
opencms.properties file. When I set a value of 1, things run really quick,
however, a value of 10 (the default) will mean a coffee break is needed
while waiting for a response.

Has anyone got an idea why this could be happening?

Regards,

Simon Wilks
software engineer
simon.wilks at silion.ch
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
silion (switzerland) ag    software engineering
spinnereistrasse 8              9008 st. gallen
tel 0878 80 90 60             fax 0878 80 90 30
info at silion.ch                    www.silion.ch

a member of the Penta Group   www.pentagroup.ch