Nintex Ideas

đź‘‹ Use this site to provide feedback and ideas for all Nintex Products. See our post on Nintex Community "Welcome to Nintex Ideas" for more details on Nintex Ideas, how an idea is handled by our product teams and more!


If you have questions about Nintex Ideas, please contact ideas@nintex.com

If you require support, please visit Nintex Customer Central

If you have a sales inquiry, please contact sales@nintex.com

Add a new idea Subscribe
Workspace K2
Categories Reporting
Created by Tin Bui
Created on Jul 25, 2024

RELATED IDEAS

Archiving Scripts Improvements

We need to archive K2 reporting data but K2 is used 24-7. Although the archiving scripts works, it creates database locks and slows down interaction with K2 sites. Would like improvement to archiving scripts to allow for execution during business hours.

  • Attach files
  • Pavel Svátek
    Jun 23, 2026

    Wouldn't someone finally like to take this idea and do something about those SQL procedures?


    The problem is that everything happens in a single transaction, during which indexes in the archive database are dropped, then records are loaded from the main K2 database into the archive, followed by the deletion of what was transferred, and finally, the indexes in the archive database are rebuilt. That transaction is incredibly large and time-consuming. When I feed those SQL queries to an AI to find bottlenecks that could be improved, it identifies them immediately.
    Archiving with the current script is, I’d say, a real pain if you’re trying to do it on a database that’s several hundred GB in size.

    Reply