title: What's the best way to delete all data from a table?
body: <p>I have a SQLite table with 6 million rows.</p>
  
  <p>Doing a DELETE FROM TABLE is quite slow;</p>
  
  <p>Dropping the table and then re-creating it seems quicker.</p>
  
  <p>I'm using this for a database import.</p>
  
  <p>Would dropping the table be a better approach or is there a way to delete all data quickly?</p>