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
