Message-Id: <22528.293418@fatcity.com> From: "Mandar A. Ghosalkar" Date: Tue, 10 Sep 2002 18:43:08 -0700 Subject: RE: Mass inserts from TCL ? 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@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@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 Mass inserts from TCL ?
Hi=20 Thomas,
 
hv u=20 checked oratcl?
metalink note 1017044.6
 
-Mandar
-----Original Message-----
From: Thomas Jeff=20 [mailto:ThomasJe@tce.com]
Sent: Tuesday, September 10, 2002 = 5:23=20 PM
To: Multiple recipients of list = ORACLE-L
Subject: Mass=20 inserts from TCL ?

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

They initially planned on a = loop within the=20 TCL code, each line item being an individual insert
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 =
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.

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

Email: thomasje@tce.com =

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