row-level locking

Ane4ka · #1 (**permalink**) 12-17-02, 16:42

We are upgrading to Sybase 12.0, which used row-level locking, before we used page-level locking. What kind of problem can we experiene?

Thanks a lot!

Bernd Dulfer · #2 (**permalink**) 12-18-02, 04:23

We are upgrading to Sybase 12.0, which used row-level locking, before we used page-level locking.

Row-level locking is available in ASE 11.9.2 too.
With ASE 12.0 you _CAN_ use row-level locking, you don't have to. So there is no reason to change anything just because you upgrade.

willy_and_the_ci · #3 (**permalink**) 12-21-02, 21:33

Hiya,

Rob put an excellent debate earlier this year on locking scheme's for a similar query. Check this out.

http://archive.dbforums.com/showthre...hreadid=359177

Cheers
Willy

Internet Services

Web Development

Digital Marketing

Consumer Tech