How to disable Android SQLite Journal file?

android sqlite journal
Arvind picture Arvind · Apr 6, 2012 · Viewed 13.2k times · Source

I am using transactions to insert multiple rows into table. But, I still see temporary sqlite-journal file being created on SD Card along with sqlite table.

How do I disable creation of journal file?

Thanks

Answer

user610650 picture user610650 · Apr 6, 2012

You can elect to keep the journal in memory so that no -journal file is created:

pragma journal_mode=memory;

Note that you need to run this each time you open the database.

I recommend that you read the following to get a better idea of what is going on:

http://www.sqlite.org/pragma.html#pragma_journal_mode

Related questions

What is the "-journal" SQLite database in Android?

In my andoid application's database directory (/data/data/com.me.myApp/databases), for every sqlite database I create there is a corresponding database of the same name with "-journal" appended to it's name. e.g: myDatabase, myDatabase-journal, myOtherDatabase.db, myOtherDatabase.…

Read More
SQLite in Android How to update a specific row

I've been trying to update a specific row for a while now, and it seems that there are two ways to do this. From what I've read and tried, you can just use the: execSQL(String sql) method or the: …

Read More
How to delete all records from table in sqlite with Android?

My app has two buttons, the first button is for deleting record on user input and the second button is for deleting all records. But when I want to delete data it shows the message "Your application has been forcefully …

Read More