we have a large Jira instance with 1000+ users and use eazyBI to provide standard reports for the organization, where Jira simply is not able to provide answers anymore. Our accounts reach ~ 300.000 issues each and ~ 10 GB database size. I already talked to the support that our long-term strategy must be to reduce these sizes and e.g. use template accounts.
After thinking about this for a bit, I have reached the conclusion that this will be a small problem for every report that starts on a certain “layer” of our task hierarchy (e.g. team reports).
But: for every report on the upper layer (e.g. regarding a Product) I will have the problem, that some of those reports rely on aggregated information from the lower layers. E.g. on the Epic level, for some reports I want to know the last sprint that a Story is currently planned for to make a prediction on the finish date. So to my understanding, I would need to import the Story level as well - which increases that account size again.
Further, there currently is no possibility to aggregate such information during the import, which ultimatively I understand as a prerequirement to splitting accounts.
Is my thinking up to this point correct or did I miss anything that could help us? Is there consultancy available to act as a discussion partner on those issues?