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

[NiveditaPDixit]

Hi,

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

[former_member1047150]

Were you able to figure that out?