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

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

Hi,
Thanks a lot man...