On 4/19/15, Joe Pasquariello <joep at fenway.com> wrote: > Since power loss occurs relatively > frequently, do you recommend synchronous=1 (Normal) or 2 (Full)?
Either will be fine. > > Can a power failure during > a COMMIT to a TEMPORARY table in memory, with synchronous=0, result in > corruption No. -- D. Richard Hipp drh at sqlite.org