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
-----Original Message-----
From: Anirban Sarkar [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 24, 2005 12:09 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] Inserting bulk data in a sqlite table
Importance: High
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 and it also works.
But my problem is that the flat file has 46000 records due to which the data
insertion process is becoming very slow.
Can anyone suggest me other ways of doing it.
Thanks in advance.
Regards,
Anirban Sarkar
--
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.322 / Virus Database: 266.11.15 - Release Date: 5/22/2005
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.322 / Virus Database: 266.11.15 - Release Date: 5/22/2005
