Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2002
    Posts
    12

    Unanswered: row-level locking

    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!

  2. #2
    Join Date
    Sep 2002
    Location
    Germany, near Aachen
    Posts
    120

    Re: row-level locking


    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.

  3. #3
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •