KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
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 : Ratio of time to load data from a file with 100,480,057 rows & 4 columns into a DB : MySQL:sqLite :: 1:1.6 Ratio of time to create an index on a given column : MySQL:sqLite :: 1: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 ??
Tags (comma-separated)
Save Edits
Cancel