<asheu@...> writes: > > > Thank you for the responses. > If we import the same text file into a MS Access database using INSERT INTO MDE SELECT * FROM > [Text;Database=C:\\folder].[filename.txt], it takes about a minute and half but because SQLite does > not support that, I have to use the insert into statement for every record inside a transaction (every > 10,000 records), it's taking 6 mins 30 secs to import the whole file. > > I was hoping there was a way to speed up that process up a little more. >
Simply structure the whole thing like this: BEGIN TRANSACTION; INSERT INTO tablename(field01,field02,...) VALUES(val01,val02,...); INSERT INTO tablename(field01,field02,...) VALUES(val01,val02,...); INSERT INTO tablename(field01,field02,...) VALUES(val01,val02,...); COMMIT; btw: put strings between '' the language is documented here http://www.sqlite.org/lang.html oliver _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
