Re: [sqlite] 转发：SQLITE3 JOURNAL MODE

2015-02-10 Thread Simon Slavin
On 11 Feb 2015, at 2:59am, Keith Medcalf wrote: >> 1) Keep it on the boot volume, not a network or external drive. > >> The following things will make your journal less safe: > >> 1) PRAGMA data_store_directory to anywhere other than the boot volume > > I presume you

Re: [sqlite] 转发：SQLITE3 JOURNAL MODE

2015-02-10 Thread Keith Medcalf
practice are combined: nothing works and no one knows why. >-Original Message- >From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- >boun...@sqlite.org] On Behalf Of Simon Slavin >Sent: Tuesday, 10 February, 2015 08:41 >To: General Discussion of SQLite Database >Sub

Re: [sqlite] 转发：SQLITE3 JOURNAL MODE

2015-02-10 Thread Simon Slavin
On 10 Feb 2015, at 9:32am, 博协软件-张涛 <2718894...@qq.com> wrote: > WHERE A POWER LOSS OR SIGNAL 'KILL -9' HAPPEND IN LINUX SYSTEM,HOW CAN I > MAKE SURE THE DB FILE HAVE THE fewest LOSS! At the same time, THE kernel > CPU period IN 30MS~50MS OR LESS. > > > I HAVE TRIED TO USE WAL JOURNAL

[sqlite] 转发：SQLITE3 JOURNAL MODE

2015-02-10 Thread 博协软件-张涛
-- 原始邮件 -- 发件人: "2718894394";<2718894...@qq.com>; 发送时间: 2015年2月10日(星期二) 下午5:31 收件人: "drh"; 主题: SQLITE3 JOURNAL MODE HELLO, I HAVE SOME QUESTIONS ABOUT USING SQLITE3 '8.8.2' WHERE A POWER LOSS OR SIGNAL 'KILL -9' HAPPEND IN LINUX SYSTEM,HOW