Hi Rajanath,
I 'm sorry, it was not 3 hrs or so, The dumping process is still running
from last 4.30 hrs and its not been loaded even 1 million of records.
I con't go for SQL Loader b/c my file is not a Datafile, its an Hash
referenced file and I need to do some process and put it in Oracle.
It will be much appreciated if you focus some light on this. :-)
Thanks,
Prem
-----Original Message-----
From: Rajanath Tadikonda [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 30, 2001 3:33 PM
To: Chouda, Prem; [EMAIL PROTECTED]
Subject: Re: How can I effeciently use Prepared Statement ?
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
_____
Get your FREE download of MSN Explorer at http://explorer.msn.com
<http://go.msn.com/bql/hmtag_itl_EN.asp>
