Hi, If should also consider using precompiled (prepared) INSERT statements.
My tests on Windows (2000 Pro) shows that the pre-compiled insert statements are faster than COPY. But this may not be the case in your situation. Make your own test if it's about 300 M as you told. Ionut Filip -----Original Message----- From: Shawn Anderson [mailto:[EMAIL PROTECTED] Sent: Friday, May 07, 2004 6:13 PM To: [EMAIL PROTECTED] Subject: [sqlite] Bulk insert or saving in memory database to file? 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 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]