bcp is faster than sqlldr???
From: jeff zhang <jeffzhangusa_at_yahoo.com>
Date: 31 Jul 2001 12:39:49 -0700
Message-ID: <f4e9a265.0107311139.3ba64b75_at_posting.google.com>
Date: 31 Jul 2001 12:39:49 -0700
Message-ID: <f4e9a265.0107311139.3ba64b75_at_posting.google.com>
Using sqlldr and Oracle8.1.6 on Unix box, I rewrite a program that
used bcp and MS SQL server7.0 on NT box.
It is to my surprise that bcp in and bcp out is much much faster than
sqlldr and
utl_file....at least 20 times faster.
In my example, it takes 27 seconds to bcp in 110007 rows into a table,
whereas sqlldr takes 6 minutes. When dump out 4000 rows of data to a
file via bcp, it takes 1 seconds, whereas util_file takes 10 minutes.
Is Oracle supposed to be faster than SQL SVR?
Any one has better way to move data out of oracle database to a flat file according to a control file?
Anyone know why? Received on Tue Jul 31 2001 - 21:39:49 CEST