Forum Stats

  • 3,825,917 Users
  • 2,260,578 Discussions
  • 7,896,735 Comments

Discussions

Settings DBAdapter

RS69
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?
pastedImage_2.png

Answers

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

    HI,

    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,
    Martien