Howdy,
I was wondering if anyone had any ideas on either of these options?
Basically I have about 300 mb of data that I want to insert in a database
using SQLite, and I am trying to find the most efficient way of doing it.
My thoughts are either to find a fast bulk insert method, or maybe using an
in memory database and then write it out at once to disk.
Thoughts and suggestions are more than welcome. BTW, I am doing this on the windows platform if that matters.
I have found the copy method to be extremely fast. Make sure the database is created, and make sure your data are in a tab delim format each row ending with \n.
> sqlite yourbigdatabase > COPY yourbigdatabase.yourbigtable FROM yourbigdatafile
done.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
