Insert Speed on 8.0.5 on Linux/Solaris

From: Alan Barclay <escribe_at_my-dejanews.com>
Date: Mon, 19 Apr 1999 11:13:25 +0100
Message-ID: <924516724.28567.0.nnrp-11.c2d97406@news.demon.co.uk>

Hi tuning gurus,

I recently wrote a 'performance testing' application (PC based) which does several thousand (small) inserts across five tables in an Oracle 8.0.5 DB. The application uses the MFC ODBC classes (yuck!).

When I run the program against two 'similar' machines (with default OS and DB installations) - I get very very different 'speed' results. Can anyone explain this? (Surely, Linux isn't this much better than Slowlaris!)
I've checked the DB inits/configs and they look the same - but maybe Oracle make some other defaults different between the two installations??

Linux RH 2.0.36 - * 285 * inserts per second on PII 350MHz / 128Mb RAM / DB on UW SCSI HD

Solaris 7 - * 81 * inserts per second
on UltraSPARC 333MHz / 128Mb RAM / DB on UW SCSI HD

Thanks for any ideas.
Alan. Received on Mon Apr 19 1999 - 05:13:25 CDT