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. Thanks Shawn