Re: [sqlite] Executing SQL from file

Hi Thanx for the responses. I've gone in the direction Dennis described - fast enough for my purposes. Fanx -- View this message in context: http://www.nabble.com/Executing-SQL-from-file-t1040732.html#a2755202 Sent from the SQLite forum at Nabble.com.

[sqlite] Executing SQL from file

Hi I'm using sqlite in a c++ program, using functions sqlite3_open, sqlite3_exec, sqlite3_close etc. I am trying to import a lot of data, probably around 100,000 rows+. I have found it quicker if I format the data into SQL statements and then use the shell statement .read to read in the SQL