Re: Oracle much slower than MS SQL Server on NT?!

Leslie,

I cut and pasted your code into our environments and ran with no modifications.
Results:

IBM RS6000 J40 (AIX 4.1.5) - Oracle 7.3.2.3:		25 seconds for 5000 records
IBM PC Server Model 520 - (WinNT 4.0) - Oracle 7.3.2.2:	55 seconds for 5000

I don't know what the hardware configurations are of our systems but both instances are setup with about 8M of db_block_buffers.

What does your init.ora file look like? How is your database server configured (memory, # of CPUs, etc.)?

Mike Morgan

L. Tseng <lesliet_at_u.washington.edu> wrote in article <5unu32$koo_at_nntp6.u.washington.edu>...
| I recently did a testing to see the performance difference
| between Oracle 7.3 and MS SQL 6.5.
|
| The test simply does 5000 and 10000 rows insert to a table, to my
| surprise, Oracle is 2-3 times slower and gets even slower when inserting
| more rows. This seems to contradict to Oracle's claim as the fastest
| database engine.
|
| The environment for testing is on the same NT 4.0 box. Two server were
| configured to use about same amount of memory. The results are:
|
| insert
| 5000 recs Oracle: 2 min. 20 sec.
| MS SQL: 58 sec.
|
| 10000 recs Oracle: 4 min. 55 sec.
| MS SQL: 1 min. 42 sec.
|
| I was wondering if anyone experience the same thing or
| anyone know some tips to speed up the Oracle.
|
| Thanks for your help in advance.
|
| Leslie
<removed the code> Received on Fri Sep 05 1997 - 00:00:00 CEST