Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Location
    india
    Posts
    12

    Unanswered: how to maintain database concurrence?

    My application uses sql for performing operation. something like conncetion.execute(query). so there is only conncetion object no recordset object or something like that .

    i want to run multiple instence of my application so i want to maintain integrety of data. and i am looking for solution through sql for locking mechanism. so concurrent data access dont currept data.

    I hope you have uderstand my requirement.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Avoid locking whenever possible! Use optimistic concurrency instead of relying on locking.

    -PatP

Posting Permissions

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