Re: Data Loading Performance Issues
From: Blv n Drms <blvndrms_at_aol.com>
Date: 1995/04/24
Message-ID: <3nfbb8$cti_at_newsbf02.news.aol.com>#1/1
Date: 1995/04/24
Message-ID: <3nfbb8$cti_at_newsbf02.news.aol.com>#1/1
Amit,
I would suggest going the Pro*C route. It will probably mean more time in
the coding phase though. The sql*loader actually creates insert
statements with rollback and commits....then the pl/sql - sql for
massaging will create additional rollback and commits and finally the move
to the permanent would create even further rollback..commits. With pro*c
you can save yourself a lot of processing time due not having the rollback
being used except on the final insert. Of course if you're rushed it will
probably be faster to code in sqlloader and pl/sql and debug.
later mater...
Jack Richter
Received on Mon Apr 24 1995 - 00:00:00 CEST