Mass inserts from TCL ?

From: Thomas Jeff <ThomasJe_at_tce.com>
Date: Tue, 10 Sep 2002 18:19:03 -0500
Message-Id: <22528.293411@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_01C25920.73D85C60
Content-Type: text/plain;

charset="iso-8859-1"

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
Select 'Indy DBA' then 'DBA Web Pages'

------_=_NextPart_001_01C25920.73D85C60
Content-Type: text/html;

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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2653.12">
<TITLE>Mass inserts from TCL ?</TITLE>
</HEAD>
<BODY>

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 SIZE=3D2 FACE=3D"Courier =

New">--------------------------------------------</FONT>


<BR><FONT SIZE=3D2 FACE=3D"Courier New">Jeffery D Thomas</FONT>

 DBA
 Thomson Information =
Services
 Thomson multimedia Inc.


Email: thomasje_at_tce.com


Indy DBA Master Documentation =
available at:
 <A =
HREF=3D"http://gkmqp.tce.com/tis_dba" =
TARGET=3D"_blank">http://gkmqp.tce.com/tis_dba</A>
 Select 'Indy DBA' then 'DBA Web =
Pages'
 <FONT SIZE=3D2 FACE=3D"Courier =

New">--------------------------------------------</FONT>

Received on Tue Sep 10 2002 - 18:19:03 CDT