Re: Oracle is painfully slow when doing massive INSERTs

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

Please check that:

1. The table doesn't have many indexes. If it does, drop them before the insert and rebuild later.
2. You commit after several records.

That might help.

Greg
>
>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.
>
>
>
Received on Wed Mar 18 1998 - 00:00:00 CST