Re: How fast is Oracle ?

Hi Richard,

try this,

increase db_block_buffers and shared_pool_size in init<your_SID>.ora dramatically.

use_asyinc_io = true in init<your_SID>.ora.

Use multiple db_writer-processes.

Reduce number of indexes associated with the insert/update table.

You have log-file and tablespace-files on different disks ?

Try rule based optimizer: 'insert /*+ rule */' hint or alter session set optimizer_goal = rule;

Try to use host arrays, maybe not possible in Pascal.

We have more than 100 inserts/updates per second sine 6.0.31 on IBM RS6000. I believe there is no performance in/de-crease with different Oracle versions.

I doubt that any other Database is faster. We tested DB2 which was significantly slower. Maybe Sybase with it page level locking is faster.

Hope that helps,

Toni

Please mail if you want to do benchmarks.

-- 
A. Dischner, AIX sysadmin, Oracle DBA           | Two planets meet;
Institut fuer Klinische Chemie                  | How are you ?
Klinikum Grosshadern                            | Bad ... , i 've got 
Ludwig Maximilians Universitaet Muenchen,  GER  | homo sapiens :-)
Marchioninistr.15 81366 Muenchen 49-89-70953202