RE: Using functions in sqlldr cripples performance

 


  _____  

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of John Dunn
Sent: Wednesday, 7 March 2007 11:09 PM
To: oracle-l
Subject: Using functions in sqlldr cripples performance


I have a Oracle 9 direct load sqlldr routine which provides adequate
performance but have now had a request to delete some characters from the
data during the load and set some fields to upper case. 
However tests show that using UPPER or TRANSLATE in the sqlldr control file
has huge negative impact on performance of the load.
 
Anyone got a solution to this ?
 
 
 
John Dunn
 
This was a well publicised bug - there was all this hoopla about "direct
load NOW with functions as well" when v9 came out, and it was pretty easy to
prove that it ran like a dog...in fact, conventional load ran much faster
than the direct counterpart.
 
So I'd try conventional load - otherwise look at doing the equivalent
functions before the load (eg in C or perl)
 
hth
connor

Other related posts: