Hi Richard, Actually, the journal file does not get deleted when I do a SELECT just after opening the database.
Why is that? NB: I do not set/modify any PRAGMA at all. Many thanks for your help! Best regards, Fabrice -----Original Message----- From: Richard Hipp <[email protected]> Sender: [email protected] Date: Sat, 15 Feb 2014 09:57:03 To: <[email protected]>; General Discussion of SQLite Database<[email protected]> Subject: Re: [sqlite] Question about how sqlite recovers after a power loss On Sat, Feb 15, 2014 at 9:55 AM, Fabrice Triboix <[email protected]>wrote: > Hi Richard, > > All right, many thanks for that. So if I do, say, a SELECT just after > opening the database, that's when the recovery will actually take place and > the journal file will be replayed and deleted. > Is my understanding correct? > yes. "SELECT count(*) FROM sqlite_master" is a good query to run for this. -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
