Semi DBA-type question

[Robert Edis]

--0-534607804-1086126741=:65170
Content-Type: text/plain; charset=us-ascii

I suggest with the new recs to a delimited ascii file with QTP and then utilising the Oracle Bulk Data Loader to insert the rows int the database.  69K rows should take seconds or at the most minutes to extract then load.
 
Blue

Guy Werry <guy.werry@hbms.ca> wrote:
I'm looking at trying to optimize a 'C' program (ick!). Part of its
processing is the insertion of approximately 69 000 records into one table.
This program typically runs for about 10 hours, unless the inserts have been
done, in which case it runs in < 1 hour.

I realize that inserting a bunch of records will take more time, but one of
my co-workers thinks that someone mentioned once that the overhead required
just to allocate table space for that volume of inserts would be
significant.

Unfortunately, our DBA has retired and so I don't have anyone to ask this
question of. We are running an older version of Oracle (7.3 something) on
HP-Ux 10.2.

So, if any of you folks with DBA-type experience has words of wisdom, I
welcome them. And, as a Powerhouse "guy", I'd really rather be writing this
in Qtp instead of "C"!

Thanks,
Guy L. Werry
Senior Systems Analyst 
Hudson Bay Mining & Smelting
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe 
" in message body to powerh-l-request@lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
--0-534607804-1086126741=:65170
Content-Type: text/html; charset=us-ascii

<DIV>I suggest with the new recs to a delimited ascii file with QTP and then utilising the Oracle Bulk Data Loader to insert the rows int the database.&nbsp; 69K rows should take seconds or at the most minutes to extract then load.</DIV>
<DIV>&nbsp;</DIV>
<DIV>Blue<BR><BR><B><I>Guy Werry &lt;guy.werry@hbms.ca&gt;</I></B> wrote:</DIV>
<BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">I'm looking at trying to optimize a 'C' program (ick!). Part of its<BR>processing is the insertion of approximately 69 000 records into one table.<BR>This program typically runs for about 10 hours, unless the inserts have been<BR>done, in which case it runs in &lt; 1 hour.<BR><BR>I realize that inserting a bunch of records will take more time, but one of<BR>my co-workers thinks that someone mentioned once that the overhead required<BR>just to allocate table space for that volume of inserts would be<BR>significant.<BR><BR>Unfortunately, our DBA has retired and so I don't have anyone to ask this<BR>question of. We are running an older version of Oracle (7.3 something) on<BR>HP-Ux 10.2.<BR><BR>So, if any of you folks with DBA-type experience has words of wisdom, I<BR>welcome them. And, as a Powerhouse "guy", I'd really rather be writing this<BR>in Qtp instead of
 "C"!<BR><BR>Thanks,<BR>Guy L. Werry<BR>Senior Systems Analyst <BR>Hudson Bay Mining &amp; Smelting<BR>= = = = = = = = = = = = = = = = = = = = = = = = = = = =<BR>Mailing list: powerh-l@lists.sowder.com<BR>Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com<BR>Unsubscribe: "unsubscribe <PASSWORD>" in message body to powerh-l-request@lists.sowder.com<BR>http://lists.sowder.com/mailman/listinfo/powerh-l<BR>This list is closed, thus to post to the list you must be a subscriber.</BLOCKQUOTE>
--0-534607804-1086126741=:65170--