huangs3
asked on
ADO: do I need to explicitly run a "commit" statement during or after a transaction?
Hi Experts:
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?
Thank you!
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?
Thank you!
# Python code 1:
# con is an ADO connection object, i is an integer
con.BeginTrans()
i = 0
while (i<500000):
con.Execute("insert into table_name (field_a, field_b) values (1,2)")
i = i + 1
con.CommitTrans()
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.