On 29 Apr 2014, at 2:24pm, Drago, William @ MWG - NARDAEAST <william.dr...@l-3com.com> wrote:
> Does closing the connection force, or at least encourage, the OS to write to > disk whatever it might have been caching? Closing a connection calls fclose() on the database file (as long as fopen() was called because at least one operation was done on the database). So the operating system does everything it would normally do in response to fclose(). This means closing a connection can take a long time because it does lots of things. For example under Windows/Mac/Unix if the file has been changed it changes the 'last modified' date on the file. Consequently you would not want to keep opening and closing a connection in a program that made a lot of changes to a SQLite database. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
