[sqlite] Journalling

[v t]

Hi,

How do I turn journalling OFF?

Inside sqlite_open function, I passed TRUE to third argument of sqliteBtreeFactory 
which stands for omitJournal. That did not work. I got an assertion in 
sqlitepager_commit. Following is the surrounding code:

  TRACE1("COMMIT\n");
  if( pPager->dirtyFile==0 ){
    /* Exit early (without doing the time-consuming sqliteOsSync() calls)
    ** if there have been no changes to the database file. */
    assert( pPager->needSync==0 );
    rc = pager_unwritelock(pPager);
    pPager->dbSize = -1;
    return rc;
  }
  assert( pPager->journalOpen );

Thanks

vt



---------------------------------
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search