Transactions are not being committed for large data

Topics brought up by the TimeTrex open source community.
Post Reply
genx86
Posts: 1
Joined: Sun Aug 07, 2016 12:10 pm

Transactions are not being committed for large data

Post by genx86 »

i've noticed a problem that either related to the system config or database's, when we have a complex subfunctions (i.e import employees) for a large number of data > 1000, everything get executed well and no error is thrown, but when i check the data is not inserted in the database, and when i remove the StartTransaction, ComitTransaction from the api, it works normally, any suggestion on how to fix this !.


ps. we use imysql driver as database.
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: Transactions are not being committed for large data

Post by shaunw »

Post Reply