kobotoolbox / kpi / 19555158077 / 2

81%

master: 76%

push

github

perf(attachments): access XForm directly from Attachment to avoid heavy joins on Instance table (#6488)

### 📣 Summary
Improve performance by linking attachments directly to their project.

### 📖 Description
This optimization allows retrieving the related `XForm` directly from
the `Attachment` model, bypassing the need to join through the
`Instance` table, which can be extremely large. By establishing a more
direct relationship, the system reduces query complexity and execution
time, significantly improving performance when loading or filtering
attachments.

7173 of 11259 branches covered (63.71%)

27521 of 33886 relevant lines covered (81.22%)

0.81 hits per line