Re: [sqlite] Inserting bulk data in a sqlite table

bulk loading should be wrapped with begin and commit statements. begin; insert into ... (a bunch more) commit; At 03:08 AM 5/24/2005, Anirban Sarkar wrote: Hi all, I have a flat file with pipe seperated data which needs to be inserted into a sqlite table. I have written a script for the same

Re: [sqlite] Inserting bulk data in a sqlite table

> > From: "Anirban Sarkar" <[EMAIL PROTECTED]> > Date: 2005/05/24 Tue AM 10:08:45 GMT > To: > Subject: [sqlite] Inserting bulk data in a sqlite table > > Hi all, > > I have a flat file with pipe seperated data which needs to be inserted into > a sqlite table. > I have written a script for the

RE: [sqlite] Inserting bulk data in a sqlite table

I am assuming you are using separate INSERT statements in your script. You can either try to use the COPY or .IMPORT commands (depending on the version of SQLite you are using), or combine the INSERT statements into a single transaction using BEGIN and COMMIT. Regards Hans -Or