Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2008
    Posts
    40

    Unanswered: Difference B\w Commit and checkpoint

    Hi,
    Can someone tell what is the difference between commit and checkpoint.
    In checkpoint the data will be written to disk.(both log and data pages).
    what happens with the commit?
    hope log pages will written am i correct. pls someone help...


    regards,
    prakashbuz

  2. #2
    Join Date
    Aug 2010
    Posts
    19

    Post

    Hi,

    this are different concepts.

    A Checkpoint "hardens" dirty pages to the disk as you describe, so
    you can go back to a consistent point in time, which is not the point of the checkpoint. A checkpoint writes dirty pages to files, in a periodic manner, which is done by the lazy writer otherwise, to reduce the recovery time in case of on error.

    A commit ends a transaction, data is written to the log file for recovery, in case of a failure.
    commit TranA Checkpoint Failure
    V v v
    TranA begin ---------
    TranB begin----------------------------------------------


    Sybase Blog sybdoc.com

  3. #3
    Join Date
    Sep 2008
    Posts
    40
    Hi,
    Thanks a lot man...

Posting Permissions

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