Re: Oracle is painfully slow when doing massive INSERTs

(posted and mailed to original author)

Wolfgang Diestelkamp wrote:
> Mark Usrey wrote:
> > > It seems to me that it all boils down to one thing: Oracle's just plain
> > > painfully slow on massive INSERT's....
 

> > > Any ideas, anyone?
 

> > You did mention any indices that are kept on you destination table. Large
 

> [...]
 

> > If you are keeping indices, try dropping them before doing the insert, and then
> > recreating them afterwards.
>
> Another reason could be that the rollback segment just grows forever if
> you don't do a commit. Try to commit every n rows (n beeing in the range
> of 100 to 1000 maybe).

commit'ing every N rows provided me with an excellent speed/performance advantage, with a moderate number of indices.

-- 
Jeff Garzik			    Typhoon, Cyclone, Diablo, and INN
http://www.spinne.com/usenet/	           News tuning and consulting