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
