Avoid Long Transactions

[JoaoMendes]

Hi !

I have a query that inserts several hundreds of thousands of recors in a table and i get this error-long transaction aborted.
Is there a way to avoid this? Is there an automated way of breaking the insert in several smaller pieces(by the way, removing the transactions in the database is not an option).

Regards

 

[olded]

Hi:

You could always increase the number and size of your logical logs, but the potential for a long-transaction is still there.

You are on the right track by limiting the size of your "insert". You don't tell us how you're inserting, but I doubt there's a way of automatically breaking up the insert without logic and code changes.

Regards,


Ed

 

[vpshriyan]

Hi Joao,

I have posted a FAQ on avoiding long transaction to this Forum. See is it of some use to you.

Regards,
Shriyan