• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

difference between dirty read and phantom

 
suekar meredilko
Ranch Hand
Posts: 153
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
whats the difference between dirty read and phantom read ? To me both looks bit same.

one transaction able to see other transactions (uncommitted) records.

bit confused
 
Frederic Esnault
Ranch Hand
Posts: 284
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
difference is :
. dirty read : data is modified between two reads;
. phantom : data appears between two reads.

In one case data was already there but changed, and in the phantom case, some new data was added between two reads.
 
suekar meredilko
Ranch Hand
Posts: 153
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
ok. New data is the key. thanks.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic