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 to 5,000.

The assembled Execute Block works great with 12 fields and 100 records, but fails at some point after that. I'm looking for a best practice solution.  Do I need to limit the number of Insert statements, or will a Commit solve the problem if inserted after every 50 or so Inserts?

Thanks in advance. I'm new to using Execute Blocks, but was unable to find a definitive "best practice" answer. Sorry if this is a duplicate question, but I really did search.