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