Hello,
I am using [mArchive] stored procedure to archive K2 Five database. Just want to know what kind of locks used in the stored procedure.
Is it table level or row level?
Can we run this stored procedure during business hours so that users can continue their work without any issues?
What will be the impact on daily work in case tables/rows locked?
Is there any measure how many rows can be archived in one go so that there should not be any impact on users?
How much time generally it takes to complete execution, first time and there after?
Thanks