Deleting a large project

Question

Hello,

we have an project in a Jira Server 7.13 instance wich serves as an archive for legacy data,

it currently holds 320K issues.

We have decided to move this project to a separate instance because we think the large number of issues is bloating up the instance and has too much of an impact on performance.

So we cloned the instance, deleted the "current" projects on the copy, but how can we get rid of the large project on the source instance?
Deleting a project with 7K issues has an ETA of over 24 hours, so i am wondering:

Is there a way to eliminate the impact of the large project that does not involve upgrading to Jira Datacenter 8 to make use of issue archiving?

Maybe one that would work as temporary workaround until there is a better solution available (Like JRASERVER-67413)?
Something like

* Disable the project on the database level
* rebuild the index

Any better suggestions? 
If not, any idea on how to disable the project?

kind regards

Jens

Jens Kisters __SeibertSolutions · Answer

In the end It took 48 Days to delete 321.000 Issues.

Fun Fact: In the beginning deleting an issue took more time than creating a new one.

But the more issues were deleted the more issues could be deleted per day.

Jens Kisters __SeibertSolutions · Answer

As no better idea came up i am going for this solution:

A cron job runs and sql containing all issues to delete and deletes the using the REST API one by one.
As the deletion of a single issue currently takes 15-20 seconds this would take the system 1-2 weeks under full load to delete them all.

I hope the time for the deletion of one issue will decrease as the number of issues decreases, we will see.

So i am scheduling this to run outside office hours and the issues will be gone in a couple of months...Yay

Jens Kisters __SeibertSolutions · Answer

In regards to "Offline archiving": the point of my question is how that could be achieved, as i'd expect

4. In your live Jira instance, select Projects from the Administration menu, then click the Delete link to delete the project and all of its issues.

Would take very long