id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
24018	Support setting pragma options for SQLite.	Curtis Maloney	Aaron Linville	"SQLite, as of 3.7, supports a WAL journal mode [https://www.sqlite.org/wal.html]

It's been my experience that enabling this can dramatically improve performance, especially under heavy writes.  I've seen some write-heavy operations go from a couple of minutes to a few seconds.

It can be enabled by executing the command:

    PRAGMA journal_mode=wal;

which will return 'wal' on success.

If it fails to apply for any reason, it will return the mode it is in - 'delete' or 'memory'.

I propose to add JOURNAL_MODE as an option to the sqlite backend.

however, some quick tinkering shows that the sqlite backend doesn't ever explicitly create the DB, so it's not immediately apparent how to detect if/when this command should be issued.

I am still investigating."	New feature	closed	Database layer (models, ORM)	dev	Normal	fixed		bcail	Ready for checkin	1	0	0	0	0	0