Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » UltraLite - Database Management and Reference » UltraLite performance tips » Insert and Update performance tips


Manage transactions and row states

UltraLite maintains state information along with the data in the database. UltraLite tracks and stores state information so it can manage:

  • Concurrent connections, so UltraLite can share resources as required.

  • Synchronization progress state, to ensure that synchronization occurs successfully.

  • Row state, to maintain data integrity by tracking how data has changed between synchronizations.

  • Transactions, to determine when and how data gets committed. In UltraLite, a transaction is processed in its entirety or not at all.

  • Recovery and backup information, to protect data against operating system crashes, and end-user actions such as removing storage cards, or device resets while UltraLite is running.

 See also

UltraLite concurrency
UltraLite database row state management
UltraLite transaction processing