My experience is that DBD::Oracle using the array interface is comparable performance-wise to SQLLDR in conventional path mode. However, SQLLDR can also be called in direct path mode, which is even faster, but you should really know what you are doing before using that. It has implications beyond the performance aspect that you need to be aware of.
If you want/need/understand using direct path, then SQLLDR is the way to go. If you want better integration with the rest of your program then DBD::Oracle is the way to go. On Sun, May 2, 2010 at 4:20 AM, Parag Kalra <paragka...@gmail.com> wrote: > Hi All, > > I want to know which one of these algorithm would be the most optimized > solution to insert large number of records and Why: > > 1. Preparing an Insert query once and executing it with place holders for > the entire set of records > 2. Executing Oracle's sqlldr command and uploading the same set of records > > Cheers, > Parag > -- "Champions do not become champions when they win the event, but in the hours, weeks, months and years they spend preparing for it. The victorious performance itself is merely the demonstration of their championship character." -T. Alan Armstrong "The Ow that can be expressed is not the true Ow." - Ao Tzu
