transaction and performance

hi guys,

I have a stupid question:

I want to use transaction in a stored procedure which is extracting data from a ERP software system and writes to a compression table. The reason for this is making sure that the data in the compression table is not inconsistent if the stored procedure fails.

Depending on the volume of data, the extraction can take quite some time (20 minutes).

Are transaction going to alter in any way the performance of the ERP software system?

Thanks a lot,

need more details

If I understand your question correctly, the answer is no.