Android Database Size Wont Decrease On Htc Thunderbolt

update: the db-wal file is what is so large. what is the cause and how do i limit sqlite logging file size? I am using a SQLiteOpenHelper. When onUpgrade occurs i am dropping every

Solution 1:

If you are using a SQLiteOpenHelper, you need to call close when your application ends. The api docs mention that you do not need to call close on all of the SQLiteDatabase instances that are opened by it, but you still must call close on the Helper because it caches and tracks all open instances of SQLiteDatabase. Without calling close, the wal file will continue to grow for every different instance that getWriteableDatabase and getReadableDatabase return.