Bookshelf Home | Contents | Index | PDF |
Siebel Remote and Replication Manager Administration Guide > Extracting and Initializing a Remote Database > Options for Extracting the Server Database > Using a Transaction Log to Optimize PerformanceWhen operating without a transaction log, SQL Anywhere must use a checkpoint at the end of every transaction. Writing these modifications consumes considerable resources, and it can degrade performance. To enable SQL Anywhere to write notes that detail modifications as they occur, you can use a transaction log. SQL Anywhere can write the new database pages all at one time and at a time that is more efficient. Checkpoints make sure information enters the server database file and that this information is consistent and up to date. To use a transaction log to optimize performance
|
Siebel Remote and Replication Manager Administration Guide | Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |