kobotoolbox / kpi / 19555158077 / 1

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.

6923 of 11247 branches covered (61.55%)

26722 of 33879 relevant lines covered (78.87%)

0.79 hits per line