Menu
I have an app which stores data in a SQLite database, when the app is just installed it uses 8kb of data and when I start inserting data obviously the size increases. The weird thing is when I start cleaning my database tables, I empty completely the database but I will never recover the first 8kb of data but much more, in some cases more than 100kb, where this data come from?
461
If your phone storage is full despite having space left on your SD card, this probably indicates your SD card is not set up as default internal storage. If so, your apps, files, and documents are stored by default in the device's internal storage. Go to settings>storage>SD Card.
It is happening as your device's Random Access Memory (RAM) has run out. So deleting photos, videos and files to get some space on phone, will also boost the RAM. Most new Android phones have no option of SD card. So eventually, users get this message as all data gets piled up in phone memory.
A database is not like a filesystem, so when you delete data from a database, you do not recover the space you previously used. The database driver will tend to prefer to keep the old allocated space.
You can compact your database, which will recover this space by manually executing the SQLite VACUUM command.
It may be possible to enable auto_vacuum mode, but this needs to be done before database creation.
169
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
