Hello sqlite users, Hello dr. Hipp, I've read the info you've provided. Thanks.
1. For Windows systems: in the CreateFileA call to open an sqlite database (os_win.c), could the file flag FILE_FLAG_WRITE_THROUGH also be specified? This flag is quite important and is also used by SQL Server when opening it's own logs and databases (seeQ234656 and Q230785 in MSDN). Quote from MSDN: "Applications can specify the FILE_FLAG_WRITE_THROUGH Win32 flag to instruct the system to write through any intermediate cache and go directly to disk. The system can still cache write operations, but cannot lazily flush them." 2. If synchronous is off, and I write a single record (a single INSERT) and a power failure occurs, will the database be affected in any way? Regards, George Ionescu