Re: Key value locking in Online 5.x

Joerg Spilker (Joerg.Spilker@p0.f0.n0.z0.aventure.teuto.de) wrote: : as i remember there are problems with the so called "key value locking" : mechanism in Online 5.x : Under some circumstances, it is possible that you can't insert a new row into a : table (where one row was locked) even if the key of the new row differs from : the key of the locked row. Small tables are a good choice for the problem. : Is there a solution for the problem in Online 6.x and 7.x ? Yes, Key Value Locking is the solution. The problem was actually called Adjacent Key Locking, where an INSERT had to test the next higher index value (adjacent key) for a lock prior to inserting. OnLine 6.0 and up use Key Value Locking, where, instead of locking adjacent rows, we added a delete flag to the index key. Try to find a copy of the TechNotes that came out in the beginning of this year. It has an article on Adjacent Key Locking and Key Value Locking. I think it's pretty good (of course, I'm biased ;-) June ---- June Tong Informix Asia/Pacific ---- ---- On-Loan Engineer Singapore ---- ---- Location-du-jour: Auckland, NZ (home of the America's Cup) ---- ---- junet@informix.com (65) 298-1716 ----