> Le 6 avr. 2017 à 17:44, Simon Slavin <slav...@bigfraud.org> a écrit : > > Can anyone point out anything that’s done to files when you close a database ?
For one thing, when the last database connection on a database file closes SQLite does checkpoint whatever remains in the wal. Which in that case includes deleting the shm/wal files. https://www.sqlite.org/wal.html#how_to_checkpoint "By default, SQLite will automatically checkpoint whenever a COMMIT occurs that causes the WAL file to be 1000 pages or more in size, or when the last database connection on a database file closes." -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia, http://integral.software _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
