Re: [sqlite] Pragmas for in-memory databases

On Sat, Apr 17, 2010 at 05:27:35PM -0700, andrew fabbro scratched on the wall: > If a DB is entirely in-memory (i.e., opened with :memory:), which pragmas > can be used to improve performance? > > (1) I assume synchronous = OFF is desirable N/A. There is no such thing as synchronizing memory w

[sqlite] Pragmas for in-memory databases

If a DB is entirely in-memory (i.e., opened with :memory:), which pragmas can be used to improve performance? (1) I assume synchronous = OFF is desirable (2) I'm guessing journal_mode = MEMORY is already set. Is journal_mode = OFF another possible speed gain? Of course, then one loses the abili