> > From: "Anirban Sarkar" <[EMAIL PROTECTED]> > Date: 2005/05/24 Tue AM 10:08:45 GMT > To: <sqlite-users@sqlite.org> > 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 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. >
Do you wrap your insertions in a single transaction ? e.g (assuming you still use Tcl) :- db1 eval begin ....insert your 46000 lines here db1 eval commit This delays the writing to the disk until you have done all your inserts. Lawrence > Regards, > Anirban Sarkar > > ----------------------------------------- Email sent from www.ntlworld.com virus-checked using mcAfee(R) Software visit www.ntlworld.com/security for more information
