Re: [sqlite] Executing SQL from file

Am 01.02.2006 um 17:10 schrieb deBooza (sent by Nabble.com): 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 s

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.

Re: [sqlite] Executing SQL from file

deBooza (sent by Nabble.com) wrote: 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

Re: [sqlite] Executing SQL from file

> 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 th

Re: [sqlite] Executing SQL from file

Something related, but that doesn't really answer the question: if you want to populate a database with so many rows, to speed up things a lot you should embed them into a transaction (or in a small number of transactions). This way, if sqlite works synchronously, it doesn't need to flush data