Finally, a test which compares the two DBMSs on the same box.
Hardware: Sun E250, 1GB, 2@400mhz cpu, single scsi drive, Solaris 2.8
Configuration
Version
Memory
Logging
Oracle
8.1.7
DB Blk Buffer=225mb SH Pool=50mb
archive mode=off
Sybase
11.0.3
64mb
trunc log/chkpt (logging on)
Timings, min:sec
Oracle
Sybase
Insert 49000 rows
3:59
1:26
Misc selects/updates
0:24
0:04
Test notes:
The test table had a mix of fields, two indexes were created before the insert run.
The test runs were achieved by submitting a SQL file to sqlplus/isql.
During the insert run, rows were batched into 100 rows/transaction. Note that
transaction logging cannot be turned off in Sybase.
Conclusion:
Our tests revealed that Sybase is significantly faster than Oracle.
Caveats: 1) The hardware used was not 'Enterprise' class, no RAID was implemented.
2) The amount of data used in the test (about 15mb worth) is fairly substantial,
but much smaller than the data manipulated in a typical enterprise class application.
Any suggestions to better match the two databases on a level playing field are
welcome - please reply to the address below.