Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What are the advantages and disadvantages of using Pessimistic Concurrency?

April 26, 2017advantages Concurrency disadvantages pessimistic

0

Posted

What are the advantages and disadvantages of using Pessimistic Concurrency?

1 Answer

0

Posted

The advantage is that the data integrity is maintained as only one transaction is allowed to write at a time. The disadvantage is the performance of the application suffers significantly because each transaction is blocked for the prior one to complete when accessing the same data.