Bill KING <[EMAIL PROTECTED]> wrote: > Is there a way to move the journal to say use a temp directory? We're > doing some stuff with dbs on SD-cards and it's dog slow. Writing to them > is dog slow too. So is transacting to them. 3 writes on sloooow media. > Is there a way to have the journal in the faster local flash memory, > then when it's done/committed, have that written to the sd media? >
The journal file must be in the same directory as the original database so that a hot journal (that results from a program crash or system power failure) can be located and used to rollback changes the next time some other program tries to open the database file. If the next user of the database cannot locate the hot journal, the journal will not be played back and the database will not be restored to a consistent state. -- D. Richard Hipp <[EMAIL PROTECTED]>
