database.Database.commit()
Syntax
commit(each=0)
Description
When called without parameters, commits any pending transactions. This means, for example, that records recently appended to a table are written to the database file. It's faster to write records to file in batches of, say, 10 000, than writing each record to the file individually. Batch transactions include the Table append() or remove() commands, or the Database sql() command. When commit() is called with the each parameter, sets the batch size. By default, transactions are commited instantly, but if you plan to add a lot of records at the same time it's better to commit them in batch. See also the close() command.
Example
Add a new page to the book and explicitly commit it:
db = ximport("database")
book = db.create("book")
book.append("pages", ["title", "text", "image", "pagenumber"])
book.pages.append(title="introduction", text="...", pagenumber="1")
book.commit()