REPOST: Oracle and SQL Server

Hello,

I am doing some comparison testing between SQL Server and Oracle for evaluation of possible migration of existing app from SQL server to Oracle. The tests involve doing full table Updates (eg Update table1 set col1 = 5; - this is basically what our system does!!) on say 500,000 rows. Running this on Oracle 8.1.6 on Sun Enterprise 450 server with files spread across 3 disks , I can get this to about 40-45 secs, with SQL Server 7 on a Compaq server with Raid 5 and 1.1 Gb CPU this takes about 3 - 4 secs. Looking at the trace files one of the problems with Oracle seems to be the amount of physical writes done to datafiles and rollback files(also redo of course), when I look at the SQL Server trace files there does'nt to be any writing done. I'm not sure if this is because they are not recorded or done at some point after the transaction has completed which would make comparison of the results difficult.
Has anyone similar experience of testing SQL Server and Oracle, or is Oracle slow at Updates, or ...??
thanks.

• WAS CANCELLED BY =======: Path: news.uni-stuttgart.de!dns.phoenix-ag.de!newsfeed01.sul.t-online.de!newsfeed00.sul.t-online.de!t-online.de!newsfeed.freenet.de!news2.euro.net!uunet!sac.uu.net!lax.uu.net!news.navix.net!u.n.a.c.4.n.c.3.l.l.e.r From: "Garrick Bigwood" <garrickb_at_software360.com> Newsgroups: news.admin.censorship,alt.test,comp.databases.oracle.server Subject: cmsg cancel <5KZX7.36613$Q66.129567_at_NewsReader> Control: cancel <5KZX7.36613$Q66.129567_at_NewsReader> Date: Wed, 2 Jan 2002 00:54:51 GMT Organization: Navix Internet Subscribers Lines: 2 Message-ID: <cancel.5KZX7.36613$Q66.129567_at_NewsReader> NNTP-Posting-Host: 166.102.15.34 X-Trace: iac5.navix.net 1009945027 21023 166.102.15.34 (2 Jan 2002 04:17:07 GMT) X-Complaints-To: abuse_at_navix.net NNTP-Posting-Date: 2 Jan 2002 04:17:07 GMT X-No-Archive: yes Comment: Dude, where's my NewsAgent? Xref: news.uni-stuttgart.de control:40280265

autocancel Received on Mon Dec 31 2001 - 07:27:57 CST