Re: Oracle is painfully slow when doing massive INSERTs

From: <soverby_at_nspr.com>
Date: 1998/03/12
Message-ID: <6e8qat$d9m$1@nnrp1.dejanews.com>#1/1

In article <3506e57f.7310326_at_news.anc.net>, jcoy@??shizz.net (John Coy) wrote:
>
> On Wed, 11 Mar 1998 20:00:17 +0100, "Morten Myrvold"
> <someone_at_somwehere.no> wrote:
> >
> >It seems to me that it all boils down to one thing: Oracle's just plain
> >painfully slow on massive INSERT's....
> >
> Just kind of a followup to this, I've also noticed that on Oracle 7.3
> the import utility is painfully slow as well. I can export data quite
> speedily, but when I use the import utility, it takes *hours* to
> import data that only took a few minutes to export.
>
> Is this normal?
>
>

It is, if there are indices on the table. For every insert, all the indices need to be updated.

The export doesn't store the actual index data, but rather the create index statement.

The export doesn't have to go thru the rollback segments or the log files.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu Mar 12 1998 - 00:00:00 CST