Importing data from a text file into SQlite Administrator takes too much time

Question

Whenever I import a text file with about 2 million rows and 2 columns into SQLite Administrator, it takes 3-4 hours to do so. Is it normal, or am I doing something wrong?

The way that I do it, is to take a tab delimited text file with rows, change the extension to .csv, and feed to SQLite Administrator. My PC specs are 2 GB RAM, Core 2 duo 1.86GHz. I also have about 10Gb free disk space when importing data.

Answer 1

Apparently, SQLite has performance issues in this field. Check this thread for more information.

You can try to do some performance tuning:

1. SQLite Docs: Pragma
2. SQLite Optimization FAQ
3. SQLite Optimization
4. SQLite Performance Tuning and Optimization on Embedded Systems