Re: Updates on Oracle and SQL Server

In article <JbZY7.45261$Q66.212435_at_NewsReader>, "Garrick says...
>
>I don't know why or how but I haven't seen my original posting of this, I
>thought it must have got lost somewhere so I re-posted, sorry, but thanks to
>all those who responded to original posting, maybe some of the original
>responders could re-send it to me.
>thanks,
>Garrick.
>

google, advanced group search.
searched comp.databases.oracle.* where author = garrickb_at_software360.com

the threads are there

http://groups.google.com/groups?q=group:comp.databases.oracle.*+author:garrickb%40software360.com&hl=en

>"Sybrand Bakker" <oradba_at_sybrandb.demon.nl> wrote in message
>news:jmh63u8jpgdmob0fdjukohfo8r60crf8to_at_4ax.com...
>> On Wed, 2 Jan 2002 13:37:39 -0000, "Garrick Bigwood"
>> <garrickb_at_software360.com> wrote:
>>
>> >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 (e.g. Update table1 set col1 =
>> >5; - this is basically what our system does!!) on 500,000 rows. Running
>this
>> >on Oracle 8.1.6 on Sun Enterprise 450 server /Solaris 8 (fairly old
>> >hardware)with files spread across 3 disks , I can get this to run at
>about
>> >40-45 secs; with SQL Server 7 on a Compaq server with Raid 5 (3 disks)
>and
>> >1.1 Gb CPU(server approx 6 months old) this takes about 3 - 4 secs. The
>> >problem with Oracle seems to be the I/O sub-system and the amount of
>> >physical writes done to datafiles and rollback files(also redo of
>course),
>> >and I'm not sure if when SQL Server completes transaction it has
>completed
>> >the writes to disk as Oracle has which makes comparison difficult. I
>think
>> >maybe the big difference in times I am seeing is combination of
>architecture
>> >differences(SQL Server would only do two writes to Transaction Logs and
>> >datafiles) and hardware differences (plus I am not using a Volume manager
>on
>> >the Unix server). Has anyone similar experience of testing SQL Server and
>> >Oracle, is Oracle slow at Updates, is it the hardware or both or ...??
>> >thanks.
>> >Garrick.
>> >
>> >
>> >
>>
>> Why do you repeat this question????? It was responded by several
>> people as you might be aware.
>> No doubt you have an out-of the box install, and if you don't follow
>> up the advice given to you, yes, then Oracle is slow at updates.
>>
>> Regards
>>
>>
>> Sybrand Bakker, Senior Oracle DBA
>>
>> To reply remove -verwijderdit from my e-mail address
>>
>
>

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp