Re: Oracle is painfully slow when doing massive INSERTs

Morten,

We use OO402 as well - and it's a good tool - but it's not what I would choose to bulk load a database. Seems to me you're getting very good performance (27 records per second) out of a client / server app.

Have you considered using SQL Loader to insert the records?

I use Pro C programs to bulk load data when that data isn't in the right format for SQL Loader - a bit more work but goes quite quickly.

Mike

Morten Myrvold wrote in message <6e6m9p$11j$1_at_elle.eunet.no>...
>I've written a utility that essentially transfer tables from one database
 to
>another (different RDBMSes). To transfer a table consisting of
>30000-something rows takes 18+++ mins to complete (number of columns
 doesn't
>seem to affect this). I'm using an ODBC cursor for selecting rows from the
>source DB and a dynaset (OO4O21) for inserting into Oracle.
>
>What I'd like to know is: Is there a way for me to speed up this process.
>
>Timing the transfer process revealed that as much as 90%++ of the time is
>spent on INSERTing into Oracle.
>
>I've tried running my databases on (almost) every possible configuration
 (on
>the same computer, on two different HDs/controllers on one computer and on
>two separate computers) - all with the same result. I've also made sure
 that
>the network traffic is as low as possible, so that's not it either.
Received on Thu Mar 12 1998 - 00:00:00 CST