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 if the application can be built in a way that allows the SQL processing to continueafter the http connection is closed (so that the user/browser isn't waiting for end of the the insert statements.) hth, chaim
Thomas Jeff <[EMAIL PROTECTED]>@fatcity.com on 09/11/2002 09:08:22 AM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Thanks for the reply, but we're using Vignette, and it's implementation of TCL. -----Original Message----- Sent: Tuesday, September 10, 2002 9:48 PM To: Multiple recipients of list ORACLE-L Hi Thomas, hv u checked oratcl? metalink note 1017044.6 -Mandar -----Original Message----- Sent: Tuesday, September 10, 2002 5:23 PM To: Multiple recipients of list ORACLE-L 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: [EMAIL PROTECTED] Indy DBA Master Documentation available at: http://gkmqp.tce.com/tis_dba Select 'Indy DBA' then 'DBA Web Pages' -------------------------------------------- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).