Home > User Voice > Archiving - improve performance

Archiving - improve performance IN BACKLOG
3

Hi All,

We had some difficulties with archiving. We had a campaign to move to archive approx 200.000 instances. It was working very slow, taking 5-6 secs per instance.
After some investigation, we found out, we can speed it up with an additional index on WFElementTasks.
After creating the index - CREATE NONCLUSTERED INDEX IX_WFELementTasks_Finished ON dbo.WFELementTasks (WFT_WFHIDTaskFinished)- it takes less than 0,3 sec per instance.
Dear Webcon team, please Include this additional index in future releases.
Thank you!

Nobody has replied in this thread yet.