In a piece of Python code using ADO, I execute a sql statement execution command inside a transaction for 500000 times like the following code. Theoretically I guess the changes will be saved after the transaction without explicitly running con.Execute("commit") during or after the transaction.
1. Is my guess correct true?
2. Will there be any problem caused by this "LARGE" transaction if I do it this way?
# Python code 1:
# con is an ADO connection object, i is an integer
i = 0
con.Execute("insert into table_name (field_a, field_b) values (1,2)")
i = i + 1