Hi Clemens,

Indeed, that would do the trick, however, during the device shutdown there is 
no way to keep the connection open. And that is really an inconvenient time to 
perform the operation due its duration. 

Cheers,
Albert

________________________________________
Od: sqlite-users-bounces at mailinglists.sqlite.org <sqlite-users-bounces at 
mailinglists.sqlite.org> w imieniu u?ytkownika Clemens Ladisch <clemens at 
ladisch.de>
Wys?ane: 27 kwietnia 2016 13:51
Do: sqlite-users at mailinglists.sqlite.org
Temat: Re: [sqlite] Controlling of check-pointing of WAL Dbs

Albert Banaszkiewicz wrote:
> 1. Is there a way to control (i.e. disable) check-pointing happening at DB 
> closure ?

The internal sqlite3WalClose() function does a checkpoint if it is able
to get an exclusive lock (which implies that there are no other readers/
writers).  So to prevent this checkpoint, you would have to keep some
other connection with an active transaction (read-only suffices) while
you're closing the first connection.  And then never close that other
connection ...


Regards,
Clemens
_______________________________________________
sqlite-users mailing list
sqlite-users at mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to