View Single Post
  #2  
Old 10-24-2006, 09:48 AM
Thalian Thalian is offline
Senior Member
 
Join Date: Jul 2006
Posts: 115
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 16
Thalian is on a distinguished road
Default

I think repeatable-read require more space to store the older version of the data so that a transaction can still read it, space can only be reclaim when no transaction requires to read that version of the data. The older version of the data is no longer required after the commit, so the space can be reused. With less storage requirements, it may store more useful data in the buffer pool. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote
  Webmaster Forums - View Single Post - read performance issue??
View Single Post
  #2  
Old 10-24-2006, 09:48 AM
Thalian Thalian is offline
Senior Member
 
Join Date: Jul 2006
Posts: 115
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 16
Thalian is on a distinguished road
Default

I think repeatable-read require more space to store the older version of the data so that a transaction can still read it, space can only be reclaim when no transaction requires to read that version of the data. The older version of the data is no longer required after the commit, so the space can be reused. With less storage requirements, it may store more useful data in the buffer pool. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote