pavani_yerra

 Profile Answers by pavani_yerra 

• Jun 18th, 2010

 

Hi,

API bulkloading is faster than file method because in convetional file method it has to write some log files and then invoke a SQl *loader. in API method it will directly connects to the sql engine.So the file method takes more time than API method.

And for regular inserts it will insert each row by row using insert statement where as in API it will load blocks of data at once.