title: VACUUMing DataBase in Android
body: <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>