title: Is SQLite really faster than MySQL ?
body: <p>Earlier I was planning on using MySQL for doing some analysis on Netflix and Twitter data. Then I thought of giving SQLite a try. Till now my experience has been : </p>
  
  <ol>
  <li><p>Ratio of time to load data from a file with 100,480,057 rows &amp; 4 columns into a DB : 
  MySQL:sqLite :: 1:1.6 </p></li>
  <li><p>Ratio of time to create an index on a given column : 
  MySQL:sqLite :: 1:3 </p></li>
  <li><p>Ratio of dropping a table  ( I made a mistake and wanted to drop and restart ) :</p></li>
  </ol>
  
  <p>The difference is huge. It took a lot of time to drop a table in SQLite. </p>
  
  <p>I was under the impression that SQLite faster than MySQL while providing most of the functionalities needed for a normal set of tasks. What am I missing ?? </p>