Posted inDynamics NAV & BC Tips & tricks

Tri-State locking in database: How-to use in AL

The tri-state locking feature is aimed at enhancing the performance and concurrency of database transactions. By enabling this feature, AL-based read operations that follow write operations are performed optimistically, rather than with strict consistency and low concurrency. Source : Roberto Stefanetti Business Central Blog Read more...
Posted inDynamics NAV & BC Tips & tricks

Transactions and Locking

AL in fundamentally a single-threaded language and as a consequence there is no support for shared data in-memory, leaving the need for traditional synchronization primitives unnecessary. Instead, the synchronization of shared data is delegated to the database. Source : BC Internals Read more...