Results 1 to 3 of 3

Thread: Difference between locking techniques

  1. Mar 29th, 2006, 11:31 PM #1
    M.Zafar Iqbal
    M.Zafar Iqbal is offline

    Thread Starter
    Lively Member
    Join Date
    Jul 2005
    Posts
    127

    Difference between locking techniques

    Hi,
    i am posting this question 2nd bcz it was not asnwered, so plz don't mind it

    Whats the difference between

    [adlockreadonly,adlockpessimistic,adlockoptimistic,adlockbatchoptimisitc]

    and

    [tablock, rowlock]
    Reply With Quote Reply With Quote
  2. Mar 30th, 2006, 03:19 AM #2
    khader82
    khader82 is offline
    Junior Member
    Join Date
    Sep 2005
    Posts
    20

    Re: Difference between locking techniques

    Zafar,

    Please refer the following link.. if u wanna know more abt it refer to MSDN


    http://docs.sun.com/source/817-2514-10/Ch11_ADO113.html

    Hope this explains
    Reply With Quote Reply With Quote
  3. Mar 30th, 2006, 03:28 AM #3
    khader82
    khader82 is offline
    Junior Member
    Join Date
    Sep 2005
    Posts
    20

    Re: Difference between locking techniques

    Hey zafar,

    This following link is much more comprehensive .. ignore the previous post..

    http://dev.mysql.com/tech-resources/...and-locks.html
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width