RE: Mass inserts from TCL ?

From: Thomas Jeff <ThomasJe_at_tce.com>
Date: Wed, 11 Sep 2002 07:02:14 -0500
Message-Id: <22541.293517@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C2598B.11473240
Content-Type: text/plain;

charset="iso-8859-1"

Thanks for the reply, but we're using Vignette, and it's implementation of TCL. -----Original Message-----
From: Mandar A. Ghosalkar [mailto:mghosalk_at_byer.com] Sent: Tuesday, September 10, 2002 9:48 PM To: Multiple recipients of list ORACLE-L Subject: RE: Mass inserts from TCL ?

Hi Thomas,

hv u checked oratcl?
metalink note 1017044.6

-Mandar

-----Original Message-----
From: Thomas Jeff [mailto:ThomasJe_at_tce.com] Sent: Tuesday, September 10, 2002 5:23 PM To: Multiple recipients of list ORACLE-L Subject: Mass inserts from TCL ?

I have a programmer inquiring as to the viability of having up to 10-15 concurrent client
sessions inserting orders that would contain anywhere from 100 to 6000 order line items each
via TCL. The orders are generated from a browser client and the whole shebang has to
be real-time.

They initially planned on a loop within the TCL code, each line item being an individual insert
into the order items table via a stored procedure. I'm still eliciting requirements, for instance,
does the whole order need to commit or can they accept a partial order, and so forth.

I'm not familiar with TCL at all, so if anyone has extensive experience in it, I would appreciate
if you could share some programming techniques or ideas as to how to perform, if possible,
some form of batch processing, rather than up to 6000 individual calls to the stored procedure.

Thanks.

Jeffery D Thomas
DBA
Thomson Information Services
Thomson multimedia Inc.

Email: thomasje_at_tce.com

Indy DBA Master Documentation available at: http://gkmqp.tce.com/tis_dba <http://gkmqp.tce.com/tis_dba> Select 'Indy DBA' then 'DBA Web Pages'

------_=_NextPart_001_01C2598B.11473240
Content-Type: text/html;

charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Mass inserts from TCL ?</TITLE>

<META content="MSHTML 5.50.4916.2300" name=GENERATOR></HEAD>

<BODY>
<DIV>Thanks for the reply, but we're using Vignette, and it's implementation of TCL.</DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left>-----Original Message----- From: Mandar A. Ghosalkar [mailto:mghosalk_at_byer.com] Sent: Tuesday, September 10, 2002 9:48 PM To: Multiple recipients of list ORACLE-L Subject: RE: Mass inserts from TCL ? </DIV>
<DIV>Hi
 Thomas,</DIV>
<DIV> </DIV>
<DIV>hv u
 checked oratcl?</DIV>
<DIV>metalink note 1017044.6</DIV>
<DIV> </DIV>
<DIV>-Mandar</DIV>
<BLOCKQUOTE

 style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid"> <DIV class=OutlookMessageHeader dir=ltr align=left>-----Original Message----- From: Thomas Jeff [mailto:ThomasJe_at_tce.com] Sent: Tuesday, September 10, 2002 5:23 PM To: Multiple recipients of list ORACLE-L Subject: Mass inserts from TCL ? </DIV> I have a programmer inquiring as to the viability of having up to 10-15 concurrent client sessions inserting orders that would contain anywhere from 100 to 6000 order line items each via TCL.     The orders are generated from a browser client and the whole shebang has to be real-time. They initially planned on a loop within the TCL code, each line item being an individual insert into the order items table via a stored procedure.   I'm still eliciting requirements, for instance, does the whole order need to commit or can they accept a partial order, and so forth. I'm not familiar with TCL at all, so if anyone has extensive experience in it, I would appreciate if you could share some programming techniques or ideas as to how to perform, if possible, some form of batch processing, rather than up to 6000 individual calls to the stored procedure. Thanks. <FONT face="Courier New"

    size=2>--------------------------------------------</FONT> <BR><FONT 
    face="Courier New" size=2>Jeffery D Thomas</FONT> <BR><FONT 
    face="Courier New" size=2>DBA</FONT> <BR><FONT face="Courier New"

size=2>Thomson Information Services Thomson multimedia Inc.

    <P><FONT face="Courier New" size=2>Email: thomasje_at_tce.com</FONT> </P>
    <P><FONT face="Courier New" size=2>Indy DBA Master Documentation available 
    at:</FONT> <BR><FONT face="Courier New" size=2><A target=_blank

href="http://gkmqp.tce.com/tis_dba">http://gkmqp.tce.com/tis_dba</A> Select 'Indy DBA' then 'DBA Web Pages' <FONT face="Courier New"

    size=2>--------------------------------------------</FONT>

Received on Wed Sep 11 2002 - 07:02:14 CDT