What is Dirty Read?

05 Apr

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 comment

Posted by on April 5, 2013 in General



Leave a Reply

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

You are commenting using your 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

%d bloggers like this: