Insert Query with place holders Vs SQLLDR

[email protected] (Parag Kalra) Sun, 2 May 2010 01:20:55 -0700

Newsgroups	perl.dbi.users
Message-ID	<[email protected]>

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

lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.