Topic: Import of 6000row from a crv file to SQLite
Hi!
I have done a import from a crv file to SQlite. Its aboyt 6000 row in that filen and it tock soooo long time to do a INSERT to my Database. About 20minutes. Can i do it on a outher way? My INSERT looks like this:
SQLExecute ('INSERT INTO Chip (No, RaceDay, Out_In, ChipNo, RowNo, Filename, Chiptype ) VALUES ("'+ sTavlnr+'","'+ sRaceday +'","'+ InttoStr(OutIn) +'","'+ Chip +'","'+ InttoStr(RowNo) +'","'+ Filename +'","'+ ChipType +'");');