What is Dirty Read?

No, it’s not reading a dirty or muddy book.

Dirty read happens in database processing when one transaction can change value and another transaction can  read the same value before the first transaction is committed or rolled back. In this case, there is a possibility the first transaction roll back causing the second transaction to read invalid value.

Although there is a way to set a database to disallow dirty read, the process degrades performance of an application because of locking overhead. It also decrease system concurrency.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s