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

  • 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.
  • There is a difference between applying a transaction and saving a transaction. What goal are you trying to achieve? We also have an administration class available.
  • Please explain the difference between applying a transaction and saving it. I am just trying to understand the documentation. There is no other goal. Please explain?