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

[Andras Balogh]

    Hello Geoff,

    You should check if the opencms DB has indexes and primary keys 
correctly set.
I remember having an issuse with MS-SQL that no indexes and PKs were set 
on the DB!
   If this is your case also, than you should take MySql indexes and 
keys as example
and create the same indexes and keys in MS-SQL.
This issue we had with 5.0.0 version so i don't know it applies also to 
5.0.1.

Best wishes,
Andras

Geoff Winkless wrote:

>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
>
>  
>