Data integrity

In Lime CRM, when data is added or updated, the process is carried out using both a database transaction and a Lime transaction to ensure data integrity and provide a reliable audit trail.

Database Transactions: These transactions are essential for maintaining data consistency. They allow for the rollback of changes in the event of an error during the update process. This capability ensures that data remains consistent and accurate, even if unexpected issues arise.

Lime Transactions: Lime transactions serve as an audit log, meticulously recording the details of data modifications. They capture which tables and records are affected, the nature of the changes made, and the identity of the user making these changes. Each Lime transaction is uniquely identified by a GUID (Globally Unique Identifier), which facilitates easy tracking of transaction details in the updatelog table.

By default, Lime transactions are retained in the database for 30 days, although this duration is configurable to meet specific requirements. This retention policy balances the need for historical audit information with database performance and storage considerations.