LOAD vs SQL INSERT

[stoggers]

Hi,

What is the relative performance of using LOAD rather than SQL insert statements? I have a bulk load via SQL that takes several hours to run and I was wondering if there would be any advantage to re-writing the source application to export data in UNLOAD format.

Any other considerations/pitfalls would be appreciated.

Regards,

Mike.

 

[amauer]

Load is much faster because it does not use a transaction log. Also, you might try dropping any indices on the table, especailly if there are several, and then recreating them after you're done inserting.