Yes, limiting number of inserts can help but.
What kind of connectivity components are you using? If firedac, then look at
array dml. It make prepared execute block for you and i can get performance e.g
200 000 records per second.
You have small record sets to import, then write insert one by one
I have a Delphi program that assembles an Execute Block with a lot of Insert
statements. The Insert statements can have an unknown number of columns up to
about 35. There are no BLOBs, and all fields are text. The records come from a
CSV or Excel file, and have an unknown number, possibly 2,000
Hello,
Is it
I know there is one field description to comment the table, I need to know
please if it is possible to add another varchar field ?
Thanks