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

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.

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