If you are inserting very small data, like 10 bytes per record, there should be no issue.
But if you have 10kb amount of data per record, you need to split them into multiple transactions, if it slows the program down or crashes. You dont want to wait 5 hours, then a record in the middle throws exception and you have to rollback the whole thing, and rerun everything right?
If you like strawberry rhubarb pie, try blueberry rhubarb (bluebarb) pie. And try this tiny ad:
a bit of art, as a gift, the permaculture playing cards