Forum Stats

  • 3,871,973 Users
  • 2,266,360 Discussions


Settings DBAdapter

RS69 Member Posts: 30 Blue Ribbon
edited Aug 11, 2020 5:10AM in BPEL

What determines the time of access to tables to write data to them?

From the amount of information transmitted?


  • Martien van den Akker
    Martien van den Akker Member Posts: 2,777 Bronze Crown
    edited Aug 11, 2020 5:10AM


    It's mainly caused by your statement which results in the exectution plan that is used by the Database to access rows. Also if you insert/update records, indexes must be updated. The more indexes and the larger the indexes, the more time it'll take. Then the more rows you update or insert, the larger your redo-log and thus the larger the commit time. Additionally, commit in itself is an expensive operation. So autocommit on ten rows is more expensive (10 commits) then one explicit commit on the set of rows. This expands on the more rows.

    kind regards,