Did you try wrapping all your INSERT statements into a single transaction? BEGIN TRANSACTION INSERT... INSERT... ... COMMIT
> -----Original Message----- > From: [email protected] [mailto:sqlite-users- > [email protected]] On Behalf Of Nigel Verity > Sent: Wednesday, May 02, 2012 12:05 PM > To: [email protected] > Subject: [sqlite] Data Import Techniques > > > Hi > I am writing an application which requires approximately 50,000 items > to be imported from a text file into a table. Each item is a single > string of 8 characters, and the target table has an auto-incrementing > PK and one other field, to hold the 8 character string. > Using the "Import Table Data" function in SQLiteman, the data loads > very quickly. However in my application, using either an SQL "insert" > command or a resultset, the import is very much slower. Is there > another technique I can use to speed things up? > Thanks > Nige > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
