RE: Mass inserts from TCL ?

From: <Chaim.Katz_at_Completions.Bombardier.com>
Date: Wed, 11 Sep 2002 11:39:28 -0400
Message-Id: <22541.293565@fatcity.com>

Jeff,
I don't know anything specific about that about performance of the tool=

you're using, but in a general way, make sure that the application can=  use
bind variables for the INSERT statement (if possible), and also check i= f
the application can be built in a way that allows the SQL processing t= o
continueafter the http connection is closed (so that the user/browser i= sn't
waiting for end of the the insert statements.) hth,
chaim

Thomas Jeff <ThomasJe_at_tce.com>@fatcity.com on 09/11/2002 09:08:22 AM

Please respond to ORACLE-L_at_fatcity.com

Sent by: root_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:

Subject: RE: Mass inserts from TCL ?

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-1= 5
concurrent client
sessions inserting orders that would contain anywhere from 100 to 6000=

order line items each
via TCL.=A0=A0=A0=A0 The orders are generated from a browser client an= d the whole
shebang has to
be real-time.

They initially planned on a loop within the TCL code, each line item b= eing
an individual insert
into the order items table via a stored procedure.=A0=A0 I'm still eli= citing
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 experienc= e 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 Received on Wed Sep 11 2002 - 10:39:28 CDT