On Thu, 2005-07-14 at 10:33 -0700, Randy Graham wrote: > On my system, deleting a table containing only a few thousand rows can take > a few minutes, since writing the journal file takes so long. >
Disabling the journal would roughly half the amount of disk (flash) I/O required. If it currently takes 2 minutes to delete, disabling the journal would reduce that to about 1 minutes. Still a long time. > I understand why the journal files exist, but would like to disable them in > some situations. > Do you also understand that if you power-off during the update, or if your program crashes for any reason, the *entire* database file will be irrecoverably corrupted if you do not have a journal? -- D. Richard Hipp <[EMAIL PROTECTED]>
