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
DB Blk Buffer=225mb SH Pool=50mb
trunc log/chkpt (logging on)
Insert 49000 rows
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.
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.