Still, it will probably go faster if you write to a text file, and
then use SQL Loader.
> -----Original Message-----
> From: Chouda, Prem [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 30, 2001 2:03 PM
> To: 'Rajanath Tadikonda'; [EMAIL PROTECTED]
> Subject: RE: How can I effeciently use Prepared Statement ?
>
>
> 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>
>
>