vendredi 1 avril 2016

VACUUMing DataBase in Android

Here it's mentioned that Vacuuming is necessary in Sqlite.

I have a Database (500MB) in my android application but after some insert and delete the size become 800MB but the database is exact as the first time.

I think Sqlite doesn't delete the empty rows.

I need to clean up the database without creating it again.

Is there any sql statement that I can use in android studio for clean up (By programming)

thank you

Aucun commentaire:

Enregistrer un commentaire