> Would it also be acceptable (assuming you want the protection offered
> by the temporary tables) to do ... "PRAGMA temp_store = MEMORY" on
> the database?
>
The temp_store pragma only effects the placement of temporary
tables. But the rollback journal is not a table. The
temp_store pragma has no effect on the placement of rollback
journals. Rollback journals always go to disk.
I am not sure of the side-effects it would lead to, but I would love
to see a "PRAGMA journal = NO".
Cheers
--
Alberto Simões
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------