Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536.1K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.6K Security Software
Settings DBAdapter
What determines the time of access to tables to write data to them?
From the amount of information transmitted?
Answers
-
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