Hi Roland
I tracked this down.
1) I had an image file of my OS and restored to my previous OS prior to
Service Pack2
this did not make a difference, so I can't blame Bill
2) if I use this ROWS loop it executers thru all 800 rows almost instantly
<@ROWS START=1 STEP=1 ARRAY="v_QuestionArray">
<BR>
<@VAR v_QuestionArray[@@Local$q_count,id_rp155category_a] SCOPE="Local">
<@VAR v_QuestionArray[@@Local$q_count,id_rp150category_b] SCOPE="Local">
<@VAR v_QuestionArray[@@Local$q_count,id_rp100question] SCOPE="Local">
<@VAR v_QuestionArray[@@Local$q_count,rp100question] SCOPE="Local">
<@VAR v_QuestionArray[@@Local$q_count,rp100_questiontype] SCOPE="Local">
<@VAR v_QuestionArray[@@Local$q_count,rp100_id_rp185] SCOPE="Local">
<@VAR v_QuestionArray[@@Local$q_count,rp100_id_rp185]>
<@VAR v_QuestionArray[@@Local$q_count,rp175_id_rp185]>
<@VAR v_QuestionArray[@@Local$q_count,rp100_rp185answerLoop] SCOPE="Local">
<@VAR v_QuestionArray[@@Local$q_count,rp100_rp185answerInsert]
SCOPE="Local">
<@VAR v_QuestionArray[@@Local$q_count,id_rp200itemanswer] Scope=Local>
<@VAR v_QuestionArray[@@Local$q_count,rp200region_type] Scope=Local>
<@VAR v_QuestionArray[@@Local$q_count,id_rp375_region] Scope=Local>
<@VAR v_QuestionArray[@@Local$q_count,rp200right_left] Scope=Local>
<@VAR v_QuestionArray[@@Local$q_count,rp200FormatDisplay_1] Scope=Local>
<@VAR v_QuestionArray[@@Local$q_count,rp200valid] Scope=Local>
</@ROWS>
3) If I put the same variables inside a LOOP ACTION it takes minutes!
4) So it is the LOOP ACTION not necessarily the INSERT.
5)Here is what I got from the debug file
6) can I use the script below inside a rows loop instead of a LOOP ACTION ?
INSERT INTO physio.rp250
(ID_RP350PROFILEID,id_rp300templateName,id_rp155category_a,id_rp150category_
b,
ID_RP100QUESTION,ID_RP200ITEMANSWER,id_rp225functmob,rp250_answ_checked,rp25
0_insertdate,rp250_insertdate_secs)VALUES
(@@local$v_NewProfileID,@@Local$v_TemplateSelect,<@VAR
v_QuestionArray[@@Local$q_count,id_rp155category_a] SCOPE="Local">,<@VAR
v_QuestionArray[@@Local$q_count,id_rp150category_b] SCOPE="Local">,
<@VAR v_QuestionArray[@@Local$q_count,id_rp100question] SCOPE="Local">,<@VAR
v_QuestionArray[@@Local$q_count,id_rp200itemanswer] Scope=Local>,
14,0,<@CURRENTTIMESTAMP FORMAT="%m/%d/%Y %I:%M:%S %p">,<@TSTOSECS
TS="<@CURRENTTIMESTAMP>">)
Thanks Janet
***********************************************************
-----Original Message-----
From: Roland Dumas [mailto:[EMAIL PROTECTED]
Sent: Sunday, October 03, 2004 12:15 PM
To: [EMAIL PROTECTED]
Subject: Re: Witango-Talk: Update & Insert Actions
Are you updating the same field in all 500 rows and updating it to the same
thing?
On 10/2/04 11:44 PM, "QSN Janet Case" <[EMAIL PROTECTED]> wrote:
> I use an UPDATE action inside a rows loop with a commit and rollback
action.
> Does every row make a fresh connection to the database?
> I am updating over 500 rows.
> Would it be better to create an SQL UPDATE script inside a rows loop and
> then
> connect to the database just once. ( if possible?)
>
> I just installed Windows XP service PAck2 and these update actions are
> taking 20 secs!
> Before it was completing in about 2-3 secs?
> I use TANGO 2000.
>
> Any body have any problems with SP2?
>
> Janet
>
>
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
