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

SQL Anywhere 17 » UltraLite - Database Management and Developer Guide » UltraLite performance tips » Insert and Update performance tips

Transaction and row state management

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.