[opencms-dev] Help with OpenCms with SQL Server Install! (Opencms 5.0)

Thu Feb 17 11:23:45 CET 2005

Eduard / Steve,

We are experimenting importants performance problems with our Opencms / 
SQL Server 2000 enviroment. The navigation in the Opencms Administration 
System and the Web is extremly slow. 

We measured the difference between the same installation with SQL Server 
and MySQL and MySQL is at least six times faster than SQL Server. In some 
web pages with SQL Server it takes 30 seconds or more to receive results 
of the web page.

Eduard, Steve: I can see that your enviroment is very similar as our 
enviroment so I'm wondering if you have the same problems of performance 
in your installation or if you solved them. 

Eduard: You mentioned some changes in the Code ¿Do these changes solved 
the performance problem? If so, ¿It would be possible that you send us 
those changes? You and Steve are the only ones that we know that use 
OpenCms / SQL Server enviroment.

We're now trying now to transform every query of "mssql/query.properties" file in Store Procedures of SQL Server as it was suggested by Geoff Winkless in the post:

http://mail.opencms.org/pipermail/opencms-dev/2004q1/009576.html

But we don't know if it will solve the problem. The performance problems 
seems to be in the "Image Type" (BLOBS) Columns of the Database Table.

Also we would like to know if you think that there is any other choice for 
solving this importante performance problem with SQL Server 2000.

Thanks in advanced. Next you can see the details of our installation:

Details of our Installation

Front-End Server

Windows 2000 Server  SP4
J2SE 1.4.2 SDK
Tomcat 4.1.30
OpenCms 5.0.1
JDBC (We tried several ones: Microsoft SQL JDBC Driver, JSQLConnect, 

Backoffice Server

Windows 2000 Server SP4
SQL Server 2000 SP3a

Pablo Baeza Bacaicoa
Línea de Negocio CRM
TELEFONICA SOLUCIONES
Tfno. 91-337-58-72
c/Sor Angela de la Cruz 2
28020 Madrid

Eduard Nesterov <edn at quadrix.com>
Enviado por: opencms-dev-bounces at opencms.org
17/02/2005 03:40
Por favor, responda a The OpenCms mailing list

        Para:   The OpenCms mailing list <opencms-dev at opencms.org>
        cc: 
        Asunto: Re: [opencms-dev] Help with OpenCms with SQL Server Install! (Opencms 5.0)

Hi Steve,

I have installed OpenCMS 5.0.1 of MS SQL Server. I had to modify some 
code and properties files. If you want I can send you the working WAR 
file. In installs without problem. The only thing you may need to do is 
to create additional indexes on the tables after you get some 
statistics. Other then that is works fine for me.

Ed

Steve Harder wrote:

>Hello,
>
>I'm trying to install OpenCMS using SQL Server, and everything seems to 
be working, except that some of the folder duplicate themselves in the 
directory tree (and the ones that do don't function correcty). I've looked 
in the archives and found others who have changed the query.properties 
file for SQL Server in the opencms.jar file. While this has fixed the 
invalid parameter error I was getting before (and I don't have the 
triplicate error either), I'm stuck with these duplicate folders.
>
>Has anyone out there successfully worked with openCMS with SQL Server?? 
This is quite important for me, please tell me anything that you can. 
>
>I'm using:
>OpenCMS 5.0.1
>Window 2000 professional
>Java 1.4.2_07
>SQL Server 2000
>
>I have used the process described here for the install:
>http://mail.opencms.org/pipermail/opencms-dev/2003q3/006752.html
>except that I'm using the query.properties file described in here
>http://mail.opencms.org/pipermail/opencms-dev/2004q1/009120.html
>
>I greatly appreciate this!
>
>Thanks,
>
>Steve
>
>
>_______________________________________________
>This mail is send to you from the opencms-dev mailing list
>To change your list options, or to unsubscribe from the list, please 
visit
>http://mail.opencms.org/mailman/listinfo/opencms-dev
>
>
> 
>

_______________________________________________
This mail is send to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please visit
http://mail.opencms.org/mailman/listinfo/opencms-dev

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20050217/dcd8426e/attachment.htm>