0 Replies Latest reply on Oct 31, 2002 9:02 PM by 362363

    Batch insert and update

    362363
      I'm searhing for a way, in OO4O, to perform a batch update on a dynaset.

      By a batch update (or insert) I mean taking a DynaSet, adding to it a large amount of rows and only
      then commiting the changes to the DB.

      until now I used ADO to perform these kind of operations, but I had a problem since I wanted to access objects like SDO_GEOMETRY.

      I've also did some time comparisons : an update of 1000 rows, took me in ADO 2 seconds, while in OO40
      (where I have to update each row individually) it took 14 seconds

      Is there a way to do what I'm looking for ?

      Thanks, Avi