VACUUMing DataBase in Android
<p><a href="https://sqlite.org/lang_vacuum.html" rel="nofollow">Here</a> it's mentioned that Vacuuming is necessary in Sqlite.</p>

<p>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.</p>

<p>I think Sqlite doesn't delete the empty rows.</p>

<p>I need to clean up the database without creating it again.</p>

<p>Is there any sql statement that I can use in android studio for clean up (<strong>By programming</strong>)</p>

<p>thank you</p>