Hi Prem,
You said you have loaded 4 million records in 3 hrs is good time but if you use some
other tools (Like SQL Loader in Oracle)which can load directly they can load less than
3 hrs
----- Original Message -----
From: Chouda, Prem
Sent: Monday, July 30, 2001 1:33 PM
To: [EMAIL PROTECTED]
Subject: How can I effeciently use Prepared Statement ?
Hi All,
I am dumping more than 4 Millions of records from Database file to RDBMS.
Here is the thing that I am doing.
1. Connecting to RDBMS and getting the $dbh
2. Opening the Database and reading all its records in LOOP
-- Creating the $sth as $sth=$dbh->prepare($sqlstmt)
-- Executing the $sth and
-- Closing the $sth
3. Closing the Database file and
4. Disconnecting the $dbh.
I thought this the way how to integrate it. But when I tested my script it
is taking more than 3 hrs in dumping all those records.
Is there something possible, where I can create the Statement once and use
it everytime instead of creating & finishing for each and every record ? OR
is there any alternative to make it effecient ?
Help || Recommendation || comments are appreciated :-)
Regards
Prem<br clear=all><hr>Get your FREE download of MSN Explorer at <a
href='http://go.msn.com/bql/hmtag_itl_EN.asp'>http://explorer.msn.com</a><br>
