After some 15 minutes I stopped the job and by then it had imported around 183.000 lines.
Then I found a tip from grabiller in 2012 in this forum where you can use BEGIN and COMMIT with SQLite
Code: Select all
DatabaseUpdate( dbid, "BEGIN;" )
DatabaseUpdate( dbid, "INSERT INTO ../.." )
DatabaseUpdate( dbid, "INSERT INTO ../.." )
; ../..
DatabaseUpdate( dbid, "COMMIT;" )
This is totally amazing to me on my old computer....