Skip to Content
Nov 04, 2016 at 05:05 AM

Hybris database transactions impact on disabling auto commit off in Microsoft SQL Server



We would like to disable the auto commit off in Microsoft SQL Server , to ensure the DB transaction is committed only on explicit commit.

I understand in impexes, the records will get committed one row at a time by the respective import thread , as it runs multi-threaded. Would it be impacted if we make auto commit off, and explicitly use transaction block for it. I am assuming all the hybris intrinsic DB operations happen in transaction block , with explicit commit.

Please confirm if my understanding is correct

Thanks, Nivedita