Page MenuHomePhabricator

support for sqlite journal in memory
Closed, DeclinedPublic

Description

To be able to rollback transactions, sqlite write a journal file on disk which is kind of slow. When one doesn't care about dataloss (ex a dev wiki), it would be nice to have the journal held in memory and thus saving disk I/O.

Doc:
http://www.sqlite.org/pragma.html#pragma_journal_mode

Whenever a connection to a sqlite file is made, one can issue the command:

pragma journal_mode=memory;

Should probably be yet another global variable such as $wgSqliteJournalMode


Version: 1.23.0
Severity: enhancement

Details

Reference
bz58776

Event Timeline

bzimport raised the priority of this task from to Low.Nov 22 2014, 2:14 AM
bzimport added a project: Wikimedia-Rdbms.
bzimport set Reference to bz58776.
bzimport added a subscriber: Unknown Object (MLST).
hashar created this task.Dec 20 2013, 11:11 PM

Mmm, so you're proposing a change analogous to downgrading MySQL from InnoDB to MyISAM?:P

For testing purpose, we don't care about lost of data during transaction, at worth test will fail :-D That is merely to speed up tests when being run against a sqlite backend.

hashar closed this task as Declined.Nov 7 2016, 9:29 AM

I am abandoning the idea, not much idea to implement that.