We are using precompiled insert statements and bind the parameters. The inserts were done in a transaction that is committed and reopened every 1000 iterations.
Ciao Sylko -----Ursprüngliche Nachricht----- Von: Alberto Simões [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 19. Juli 2007 11:57 An: sqlite-users@sqlite.org Betreff: [sqlite] Importing a big text file (CSV?) Hi I have a file (big file with 16 000 000 lines) with records like 2 3 4 4 3 2 5 4 387 5 8 5473 ... and I want to import this to an SQLite table. Although I can replace all this to INSERT commands very easily, I would like to ask first if there is any faster method. Cheers Alberto -- Alberto Simões ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------