[opencms-dev] SQL Server - Many many connections and dire performance

[Geoff Winkless]

Even though I have set the connection pool settings in
opencms.properties to have a "max connections" setting of 10 the OpenCMS
system still opens up about 100 connections to SQL Server.

We're also getting stupidly poor performance: opening and then closing a
file in the source editor, for example, takes around 1 minute 10
seconds.

The SQL Server is on a different machine to the Tomcat installation -
would you recommend moving it onto the same machine? The network is
locally switched 100Mb.

Neither machine is heavily loaded and each has plenty of free (physical)
memory.

None of the pages to be edited is particularly large.

Tomcat 4.1.29
OpenCMS 5.0.1 Fat install
Win2k

MS SQL Server 2k Developer Edition
NT4 Workstation (nothing else running and not logged in)

Thanks for any suggestions.

Geoff


________________________________________________________________________
This email has been scanned for all viruses by the MessageLabs Email
Security System. For more information on a proactive email security
service working around the clock, around the globe, visit
http://www.messagelabs.com
________________________________________________________________________