Import csv long file into sqlite database takes too long

SirTom,

Another way to import files is you could upload the file to the server and then use command line file import for sqlite https://www.sqlite.org/cli.html#section_8.

That is only useful if you have the correct matching file to table layout.

I have had to do this with 100,000+ rows with MySql and it was VERY quick. I would just upload the file then run the command line to do the import (LOAD DATA INFILE Syntax).

Again only if your file matches your table.

iWAT LLC - Application Development & Website Creation