VACUUMing DataBase in Android

Question

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

Related: http://stackoverflow.com/questions/23053462/sqlite-vacuum-command — Morrison Chang, Apr 01 '16 at 18:38
**Morrison Chang**, There isn't any answer for the question that you put the link. Instead of giving the negative point answer me. . **CL**: I want to codding in android. — Malus Jan, Apr 01 '16 at 21:37
You "think" it doesn't delete empty rows? That is easily checkable by using the DDMS tools or a SQLite database browser program — OneCricketeer, Apr 02 '16 at 03:18

score 1 · Accepted Answer · answered Apr 02 '16 at 03:11

Someone already said you linked to it. You asked this...

Is there any sql statement

The doc you linked to contains a link to this...

http://sqlite.org/syntax/vacuum-stmt.html

The vacuum command is a statement. That means you would call it the same way you would a select statement.

VACUUMing DataBase in Android

1 Answers1