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 :

  1. Ratio of time to load data from a file with 100,480,057 rows & 4 columns into a DB : MySQL:sqLite :: 1:1.6

  2. Ratio of time to create an index on a given column : MySQL:sqLite :: 1:3

  3. Ratio of dropping a table ( I made a mistake and wanted to drop and restart ) :

The difference is huge. It took a lot of time to drop a table in SQLite.

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 ??

mysql performance sqlite
Edit
Report