1
48%
main: 48%

Ran 12 Jul 2026 04:11AM UTC

Files 252

Run time 6s

Badge

Embed ▾

Committed 12 Jul 2026 03:58AM UTC coverage: 47.674% (-0.03%) from 47.707%

Job # 29179017047.1

Build Type

Pull #729

github

Committed by

sandonemaki

Commit Message

perf(gen): match copyMatchingRows rows via a map keyed by the primary key

The generated copyMatchingRows (used by UpdateAll, DeleteAll, ReloadAll
and MergeMod to stitch RETURNING rows back into the slice) matched every
slice element against every returned row in a nested loop — O(N×M)
primary-key comparisons, ~25 million for a 5,000-row UpdateAll.

When the table has a single primary key column whose type is comparable
with ==, build a map from the returned rows keyed by the primary key
(keeping the first row per key, like the nested loop's break) and stitch
in O(N+M). Composite primary keys and custom compare_expr types keep the
previous nested loop, mirroring the gating used by the relationship
loader map-stitch (#706).

Standalone benchmark of the two generated shapes (N slice rows matched
against M=N returned rows):

    N=100    4.5µs  →  20µs   (map alloc dominates, negligible vs the query)
    N=1000   411µs  →  215µs  (1.9x)
    N=5000   26.1ms →  1.1ms  (23x)

Pull Request Pull Request #729: perf(gen): stitch copyMatchingRows via a map keyed by the primary key (O(N×M) → O(N+M))

Coverage Stats

11849 of 24854 relevant lines covered (47.67%)

364.3 hits per line

stephenafamo / bob / 29179017047 / 1
48%
main: 48%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Source Files on job go-oldstable - 29179017047.1

stephenafamo / bob / 29179017047 / 1 48% main: 48%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Source Files on job go-oldstable - 29179017047.1

stephenafamo / bob / 29179017047 / 1
48%
main: 48%

README BADGES
x