joaoh82 / rust_sqlite / 25514942813
64%

DEFAULT BRANCH: main
Ran
Jobs 1
Files 51
Run time 1min
Badge
Embed ▾
README BADGES
x

If you need to use a raster PNG badge, change the '.svg' to '.png' in the link

Markdown

Textile

RDoc

HTML

Rst
coverage: 64.728%. Remained the same
25514942813

push

github

web-flow 
feat(bench): Group B workloads — W7..W9 (SQLR-16, sub-phase 9.3) (#104)

Lands the SQL-feature-scaling workloads on top of the 9.2 Group A
baseline:

  W7 aggregate    SELECT SUM(v) FROM big over 1M rows.
                  Single-statement full-scan + accumulator.
  W8 group-by     SELECT k, COUNT(*) FROM big GROUP BY k at three
                  cardinalities (10 / 1k / 100k distinct groups).
                  Each cardinality is its own criterion group.
  W9 inner-join   customers ⨝ orders ON c.id = o.customer_id,
                  per-PK-probe shape, single matching order per
                  customer.

Two notable plan deviations land alongside the workloads, both
captured in code + README:

W8 / 100k-cardinality on SQLRite — skipped by default. A first
measurement clocked ~245 s per criterion iteration (~41 min for
10 samples), strongly suggesting an O(n × cardinality) GROUP BY
path. Setting `SQLRITE_BENCH_W8_CARD_100K_SQLRITE=1` re-enables
the bucket. SQLR-19 tracks the investigation. SQLite runs the
same bucket fine.

W9 dataset scaled 100k rows → 10k rows. Plan target was two
100k-row tables, but a first smoke ran 88 minutes on SQLRite
without producing a single sample. SQLRite's join executor
(`src/sql/executor.rs::execute_select_rows_joined`) is a
left-folded nested-loop driver with no inner-side index probe,
so per-PK probe walks every row in `orders`. SQLR-20 tracks
the planner / index-pushdown fix; bumping back to 100k follows
that + a `W9.v2` tag.

Smoke run (M1 Pro, criterion --warm-up-time 1 --measurement-time 1
--sample-size 10):

  W7         sqlrite ~111 ms / sqlite ~31 ms       — ~3.5x
  W8 card-10  sqlrite ~204 ms / sqlite ~460 ms     — sqlrite wins (small samples;
                                                     SQLite picks sort-then-group)
  W8 card-1k  sqlrite ~1.50 s / sqlite ~242 ms     — ~6.2x
  W8 card-100k sqlrite SKIPPED / sqlite ~241 ms    — ⚠ SQLR-19
  W9 (10k)   sqlrite ~32 s / sqlite ~2.3 us         — ~14_000_00... (continued)

8704 of 13447 relevant lines covered (64.73%)

1.2 hits per line

Jobs
ID Job ID Ran Files Coverage
1 25514942813.1 51
64.73
 GitHub Action Run
Source Files on build 25514942813