Some times writes that have been cached will not be written to disk. In code we use the flush() to insure changes are made. In the OS we need to be sure that the system has been shutdown properly.
.02 ends. Sent from my iPhone > On Jun 8, 2016, at 7:20 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > >> On 7 Jun 2016, at 8:13am, 刘翔 <liuxi...@pset.suntec.net> wrote: >> >> Problem: >> When update database and power off immediately, > > How soon do you turn the power off ? Two seconds ? Ten seconds ? One > minute ? > > What type of hard disk do you have ? Is it a rotating disk or a solid state > drive ? > > Is the drive you have the database on the boot drive of the computer ? > > If you try to make a database on an external drive (Flash drive ? External > rotating drive ?) instead of the drive you were using, do you see the same > problem ? > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users