I want to write 5000 rows to the database file in two steps:
1)First write 100 files as temp DB and commit and begin new transaction. Readers will see only 100 files.
2)Keep writing remaining 4800 files,and commit at the end. After commit users will see all 5000 files.
I am using WAL mode for concurrency. So do I need to call sqlite3_wal_checkpoint_v2() such that changes are written to the database file or commit will take care of that?
Aucun commentaire:
Enregistrer un commentaire