The big thing to fix is the validity lookups : eager load the relevant people, will save 4 seconds or so straight up. That combined with the better query for bmps should save 50% of the render time.
The big thing to fix is the validity lookups : eager load the relevant people, will save 4 seconds or so straight up. That combined with the better query for bmps should save 50% of the render time.