Topic: Job and transaction
There was a task to launch process of generation of "codes". It is possible to launch process that one million such codes, operation heavy enough created and each code is record in some tables. Selected for this purpose that to itself there by hours it was twisted and did not hinder. The configuration is transited, thanks . The new problem is transaction in .
How much understood, and checked up , together with transaction starts. It is necessary each successful pack from 1.000 codes , everyone it is erratic to roll away the code since it is record in some tables.
For the notification about the status procedure which will be written to write down the data in the table through loopback, such independent transaction.
Actually a problem with packs and rollbacks:
Packs. If I start the transaction that all it expects exterior transaction, i.e. I do not see given by hours yet all does not end . but it is natural counters of transaction do not converge. I suspect that transaction log all this time will swell without physical , are ignored.
Rollbacks. Here on savepoint likely it is possible. Whether whether loads strongly the server creation savepoint for each iteration and correct is the approach.