On 2 Jan 2011, at 10:11pm, Simon Slavin wrote: > It will take less memory and be faster if you do it line by line: read one > line of the .csv file, then write one row to your SQLite table, then read the > next line.
Sorry, I forgot: SQLite will make changes faster if you bundle them all together in one TRANSACTION: CREATE TABLE ... BEGIN TRANSACTION INSERT ... INSERT ... INSERT ... END TRANSACTION Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
