Settings DBAdapter

RS69

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

From the amount of information transmitted?

Martien van den Akker

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