read performance issue??

[DArnold]

hi all,
I use repeatable read transaction isolation level in my database. Tables have lots of concurrent insert activity, very rare update/delete activity, and occasional select activity. Plz tell me what locking situations betwen users will speed up as a result of going from repeatable read to committed read?
Thanks, -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[Thalian]

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 --