[sqlalchemy] SQLite synchronous on engine

2013-06-19 Thread pr64
Hi, In order to improve the underlying SQLite performance, I've changed some low level settings with PRAGMA commands: PRAGMA synchronous=NORMAL; /* instead of default FULL value, see: http://www.sqlite.org/pragma.html#pragma_synchronous */ PRAGMA journal_mode=WAL; /*

Re: [sqlalchemy] SQLite synchronous on engine

2013-06-19 Thread Michael Bayer
On Jun 19, 2013, at 10:14 AM, pr64 pierrerot...@gmail.com wrote: Hi, In order to improve the underlying SQLite performance, I've changed some low level settings with PRAGMA commands: PRAGMA synchronous=NORMAL; /* instead of default FULL value, see: