I see a statement in the forum in the checkpointing section --> "Each wr

I see a statement in the forum in the checkpointing section --> "Each write transaction is applied immediately to the engine in memory and saved to the transaction log."

Where does this transaction log physically reside on the disk on the server? What is the filename called and what is file path?...

OriginalPostID-107166

OriginalPostID-107166

  Discussion posts and replies are publicly visible

Parents
  • Hi Myles, the documentation is a little confusing. If you say that the transaction log is the most recent applicable *.kdb file, then it means that the write transaction is applied to the engine in memory and to the most recent applicable *.kdb file. Then what does checkpointing do? It says --> "When a checkpoint completes, the transaction log is applied to the database and the transaction log is cleared". If transaction log = most recent applicable *.kdb file, then it would mean , When a checkpoint completes, the most recent applicable *.kdb file is applied to the database and the most recent applicable *.kdb file is cleared. Please explain. Does checkpointing create only a new .kdb file? But then why do we need to create a new .kdb file if every time a write transaction is applied immediately to the engine in memory as well as the most recent applicable .kdb file?

    "When a checkpoint completes, the transaction log is applied to the database" --> In this statement, what is the database? Is it KDB?

    Somebody who has no knowledge about Appian, wouldn't understand what is checkpointing with this documentation.

    Please explain clearly.
Reply
  • Hi Myles, the documentation is a little confusing. If you say that the transaction log is the most recent applicable *.kdb file, then it means that the write transaction is applied to the engine in memory and to the most recent applicable *.kdb file. Then what does checkpointing do? It says --> "When a checkpoint completes, the transaction log is applied to the database and the transaction log is cleared". If transaction log = most recent applicable *.kdb file, then it would mean , When a checkpoint completes, the most recent applicable *.kdb file is applied to the database and the most recent applicable *.kdb file is cleared. Please explain. Does checkpointing create only a new .kdb file? But then why do we need to create a new .kdb file if every time a write transaction is applied immediately to the engine in memory as well as the most recent applicable .kdb file?

    "When a checkpoint completes, the transaction log is applied to the database" --> In this statement, what is the database? Is it KDB?

    Somebody who has no knowledge about Appian, wouldn't understand what is checkpointing with this documentation.

    Please explain clearly.
Children
No Data