[opencms-dev] OpenCMS and SQL server 2000

[Ariel Spivakovsky]

Mark:

I also have the 3 of each item problem in the administration view, but only if offline or a project are selected.  online it looks fine.

This seems to be only a cosmetic problem, but I could be wrong.

I'm using an inet driver and I don't see any performance problems.

performance in this case could also be caused by the driver, the network connection or the sql server itself.

It could also be that what a perceive as normal, you perceive as slow. ;-)

Best
Ari

--

--------- Original Message ---------

DATE: Fri, 18 Jul 2003 16:57:01
From: opencms-dev-request at opencms.org
To: opencms-dev at opencms.org
Cc: 
From: "Mark Miller" <mark.miller at hema.ch>
To: <opencms-dev at opencms.org>
Subject: AW: [opencms-dev] OpenCMS and SQL server 2000 problem
Date: Fri, 18 Jul 2003 15:40:22 +0200
Reply-To: opencms-dev at opencms.org

I did manage to get it working ... but I found it extremely slow ... I
think that MS didn=92t really bother with trying to add any =
optimisations
to their jdbc driver.

I did have a problem though after I removed the project_id from the
where clause (as stated somewhere in the archives), I got an icon for
every project, ie. 3 of each admin icon ... maybe I did something wrong,
but I couldn't be bothered to look further into it due to the
performance.

Yesterday I moved back to my SQL, and the whole thing seems to run much
faster ... really strange.

And usually I am a complete fan of MS SQL ... oh well,






Need a new email address that people can remember
Check out the new EudoraMail at
http://www.eudoramail.com