[email protected] wrote: > If we import the same text file into a MS Access database using INSERT INTO > MDE SELECT * FROM > [Text;Database=C:\\folder].[filename.txt], it takes about a minute and half > but because SQLite does not support that, I have to > use the insert into statement for every record inside a transaction (every > 10,000 records), it's taking 6 mins 30 secs to import > the whole file.
Make sure you prepare the statement once, then just bind parameters for every row. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
