Re: Oracle is painfully slow when doing massive INSERTs

From: Keith Boulton <boulkenospam_at_globalnet.co.uk>
Date: 1998/03/12
Message-ID: <35081fcd.5119641@read.news.global.net.uk>#1/1

On Wed, 11 Mar 1998 20:00:17 +0100, "Morten Myrvold" <someone_at_somwehere.no> wrote:

>
>Hi all...
>
>Hope someone can help me with this one (kinda newbie question):
>
>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.

Write the data to a file and use direct path sql*loader. Received on Thu Mar 12 1998 - 00:00:00 CST