releasing a transaction handle

[sidnt]

release the transaction handle:

The transaction handle may be discarded using mdb_txn_abort() or mdb_txn_commit().

the former will, effectively,

Abandon all the operations of the transaction instead of saving them.

and the latter, will, effectively

Commit all the operations of a transaction into the database.

---

[sidnt]

Avoid long-lived transactions.

• Read transactions prevent reuse of pages freed by newer write transactions, thus the database can grow quickly.
• Write transactions prevent other write transactions, since writes are serialized.