RE: Mass inserts from TCL ?

From: Mandar A. Ghosalkar <mghosalk_at_byer.com>
Date: Tue, 10 Sep 2002 18:43:08 -0700
Message-Id: <22528.293418@fatcity.com>

This is a multi-part message in MIME format.

------_=_NextPart_001_01C25934.946D3D56
Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi Thomas,
=20
hv u checked oratcl?
metalink note 1017044.6
=20
-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=20
sessions inserting orders that would contain anywhere from 100 to 6000 = order line items each=20
via TCL. The orders are generated from a browser client and the = whole shebang has to=20
be real-time.=20

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

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

Thanks.=20

--------------------------------------------=20

Jeffery D Thomas=20
DBA=20
Thomson Information Services=20
Thomson multimedia Inc.=20

Email: thomasje_at_tce.com=20

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

--------------------------------------------=20

------_=_NextPart_001_01C25934.946D3D56
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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

<META content=3D"MSHTML 6.00.2719.2200" name=3DGENERATOR></HEAD>
<BODY>
<DIV>Hi=20
Thomas,</DIV>
<DIV><FONT face=3DArial color=3D#0000ff =

size=3D2> </DIV>
<DIV>hv u=20
checked oratcl?</DIV>
<DIV><FONT face=3DArial color=3D#0000ff =

size=3D2>metalink note 1017044.6</DIV>
<DIV><FONT face=3DArial color=3D#0000ff =

size=3D2> </DIV>
<DIV><FONT face=3DArial color=3D#0000ff =

size=3D2>-Mandar</DIV>
<BLOCKQUOTE=20

style=3D"PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px = solid">
 <DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft>-----Original Message----- From: Thomas Jeff=20 [mailto:ThomasJe_at_tce.com] Sent: Tuesday, September 10, 2002 = 5:23=20
 PM To: Multiple recipients of list = ORACLE-L Subject: Mass=20
 inserts from TCL ? </DIV> I have a programmer inquiring = as to the=20
 viability of having up to 10-15 concurrent client <FONT=20 face=3D"Courier New" size=3D2>sessions inserting orders that would = contain=20
 anywhere from 100 to 6000 order line items each <FONT=20 face=3D"Courier New" size=3D2>via TCL.     The = orders are=20
 generated from a browser client and the whole shebang has to =
 <FONT=20

 face=3D"Courier New" size=3D2>be real-time. They initially planned on a = loop within the=20
 TCL code, each line item being an individual insert <FONT=20 face=3D"Courier New" size=3D2>into the order items table via a stored=20 procedure.   I'm still eliciting requirements, for instance, =

does the whole order = need to commit=20
 or can they accept a partial order, and so forth. I'm not familiar with TCL at = all, so if=20
 anyone has extensive experience in it, I would appreciate =
 <FONT=20

 face=3D"Courier New" size=3D2>if you could share some programming = techniques or=20
 ideas as to how to perform, if possible, some form of batch processing, rather than up to 6000 = individual calls=20
 to the stored procedure. 
 Thanks. <FONT face=3D"Courier New"=20

  size=3D2>--------------------------------------------</FONT> <BR><FONT =

face=3D"Courier New" size=3D2>Jeffery D Thomas DBA Thomson = Information=20
 Services Thomson = multimedia=20
 Inc. 
 Email: thomasje_at_tce.com =


 Indy DBA Master Documentation = available=20
 at: <A=20 href=3D"http://gkmqp.tce.com/tis_dba"=20 target=3D_blank>http://gkmqp.tce.com/tis_dba</A> <FONT=20 face=3D"Courier New" size=3D2>Select 'Indy DBA' then 'DBA Web = Pages'=20
 <FONT face=3D"Courier New"=20 Received on Tue Sep 10 2002 - 20:43:08 CDT