Skip Navigation LinksHome Page > Forums > SpiraTeam Forums > SpiraTeam Issues & Questi... > Purging Old Test Runs
Just wondering if there are others out there that have experienced the same problem as me, and if so do you have a solution?
We are now approaching the 3 million test run mark and would really appreciate a script to purge old runs.
Manually deleting test runs is a pain to say the least and attempting to create a script is asking for trouble.
I mentioned this to Inflectra a good while back and was told they were looking in to it as they have the same problem when running automated tests.
One of the reasons why it's tricky is that the execution status of the test cases, requirement, test sets, and releases is all derived from the test runs. If you purge a bunch of old test runs you may potentially set test cases back to 'Not Run'.
One idea we had is to delete all but the most recent test run that matches any specific unique combination of test set, test case, custom properties, release, etc. but then you have test configurations, so even that may not be correct anymore....
Thanks for the response Jim, I understand its a tricky issue but none the less its not going to dissapear and the longer your customers stay loyal the more will be wondering how to do this in a more efficient manner as data grows.
In our own application we've adopted a background process approach for purging unwanted/deprecated records, the proces is highly parameterized and with the possibility to schedule.
I think this would be a good approach even for Spira.
Just my thoughts.