Test Run Status custom field takes at least 50% of the time spent on Xray entities when reindexing Jira

The reindex time of a Jira instance takes as much time as the amount of data it contains.

Although, the Test Run Status custom field takes approximately 50% of the time spent when indexing Xray entities.

As an example:

*considering a database query takes ~10ms

A solution should be considered in order to reduce this time. A cache of TestRunStatus should be considered to reduce the number of queries needed to index this value for every test issue.