Difference between OCC and PCC

OCC: - Optimistic Concurrency Control
           Optimistic Concurrency Control (OCC) helps increase database performance, Optimistic Concurrency only locks records from the time when the actual update is performed
OCC Enabled: Yes
PCC: - 
           Pessimistic Concurrency Control locks records as soon as they are fetched from the database for an update. Pessimistic concurrency was the only option available in Microsoft Axapta 3.0 (now a part of Microsoft Dynamics). 

Comments

Post a Comment

Popular posts from this blog

AX7/D365/Operations: Enable/Disable form control in X++

https://dynamicsaxinsight.wordpress.com/2017/09/12/ax7-d365-operations-enable-disable-form-control-in-x-plus-plus/ Purpose: The purpose of this document is to demonstrate how we can enable/disable a form control in X++ based on a business logic. Product: Dynamics 365 for Finance and Operations, Platform Update 9. Development approach: Customization through extension. Development: Create a post event handler of a standard form method enabling/disabling the form controls. In this case, we are creating a post event handler of a standard method setFieldAccessHeader of SalesQuotationProjTable form. Please find the event handler method definition as follows. [PostHandlerFor(formStr(SalesQuotationProjTable), formMethodStr(SalesQuotationProjTable, setFieldAccessHeader))] public static void SalesQuotationProjTable_Post_setFieldAccessHeader(XppPrePostArgs args) { FormRun sender = args.getThis(); FormDataSource salesQuotationTable_ds; SalesQuot...
Read more

AX 2012: Multi-Select Lookup for SSRS Report Dialog

Image
AX 2012: Multi-Select Lookup for SSRS Report Dialog https://dynamicsaxinsight.wordpress.com/2014/12/12/ax-2012-multi-select-lookup-for-ssrs-report-dialog/   muhammadanaskhan     Development (AX 2012) ,  Dynamics AX 2012 ,  SSRS Reports ,  Technical (AX 2012)     December 12, 2014   2 Minutes Overview: In this post we’ll learn how to build multi-select lookup for SSRS report dialog. We’ll create an RDP report with an AutoDesign layout. Controller will be used to run the report. An output menu item will be created to point to the controller class. Each AOT element involved will be described in detail. You can guess the complexity of this development task by looking at the AOT elements required for it: Let’s develop them piece by piece… 1. MAKCustTable (Query): 1. Create MAKCustTable query. 2. Drag CustTable table to the data sources node. 3. Select the fields as shown in the picture. 2. Tm...
Read more

Dialog fields and runtime lookups / Simple UI Builder Class on SSRS Report parameters [Dynamics AX 2012] && Filtering drop down list based on another drop down

Image
In this post, we will learn how to add dialog fields and get run time lookups on the dialog field in AX 2012 SSRS reports. In Dynamics AX 5.0, we used to get this by overriding dialog, dialogpostrun, controlMethodOverload, Field_runTimeFieldId_lookup/modified methods  etc. In AX 2012 there is a class by name “ SrsReportDataContractUIBuilder”  to serve the same purpose. Example : In the below screen shot, I have added dialog field “Filter by Cust” and in the lookup it will only display the customers who belongs to customer group “20”. Interesting right, now lets see how to accomplish this: Create a new Query by name “SRCustTable” and add data source as “CustTable” as shown below Then create a new temporary Table by name  TmpSRSalesTable  and add 2 fields CustAccount and SalesId fields as shown below. Now, we need to create contract classes, DP class and Builder class as shown below. Follow the below classes and methods. SRCustomLookupUIBuilde...
Read more