Unleash / unleash / 8733141065

86%

master: 91%

push

github

feat: optimize applications overview query (#6883)

We encountered an issue with a customer because this query was returning
3 million rows. The problem arose from each instance reporting
approximately 100 features, with a total of 30,000 instances. The query
was joining these, thus multiplying the data. This approach was fine for
a reasonable number of instances, but in this extreme case, it did not
perform well.

This PR modifies the logic; instead of performing outright joins, we are
now grouping features by environment into an array, resulting in just
one row returned per instance.

I tested locally with the same dataset. Previously, loading this large
instance took about 21 seconds; now it has reduced to 2 seconds.
Although this is still significant, the dataset is extensive.

2620 of 3443 branches covered (76.1%)

10 of 49 new or added lines in 1 file covered. (20.41%)

12819 of 14640 relevant lines covered (87.56%)

675.18 hits per line