Optimistic Concurrency Control (OCC) Property in Dynamics Axapta
Definition Optimistic Concurrency Control (OCC) helps increase database performance. Pessimistic Concurrency Control locks records as soon as they are fetched from the database for an update. However, Optimistic Concurrency only locks records from the time when the actual update is performed. Pessimistic concurrency was the only option available in Microsoft Axapta 3.0 (now a part of Microsoft Dynamics). You can now choose which concurrency model to use—optimistic or pessimistic. RecVersion is a 32-bit signed INTEGER. But it will never get a negative value assingned through the AOS. Advantages Fewer resources are used to hold the locks during the update process. Records are locked for a shorter length of time. Records remain available for other processes to update if they have been selected from the database but haven't yet been updated. Disadvantages The disadvantage of using OCC is that the update can fail if another process updates the same record. I