develooper Front page | perl.dbi.users | Postings from May 2010

Insert Query with place holders Vs SQLLDR

Thread Next
From:
Parag Kalra
Date:
May 2, 2010 01:21
Subject:
Insert Query with place holders Vs SQLLDR
Message ID:
o2u736082cf1005020120w62ba0a8bl88f3c2d7cf4f322b@mail.gmail.com
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
Thread Next

nntp.perl.org: Perl Programming lists via nntp and http.
Comments to Ask Bjørn Hansen at ask@perl.org | Group listing | About