• kent
  • Member
  • Offline
  • Registered: 2015-12-04
  • Posts: 13

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 +'");');

  • Registered: 2014-06-25
  • Posts: 863

Re: Import of 6000row from a crv file to SQLite

Have you ever considered using "begin transaction" to insert your data at once? http://stackoverflow.com/questions/2121 … ion-needed

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Import of 6000row from a crv file to SQLite

kent
Please download this example:
http://myvisualdatabase.com/forum/misc. … download=1

Dmitry.