Keyboard shortcuts

Press ← or → to navigate between chapters

Press S or / to search in the book

Press ? to show this help

Press Esc to hide this help

Cross-ORM benchmark results

This document records an apples-to-apples benchmark of ruprizzle, prax, Sea-ORM, Diesel, Prisma, and Drizzle against the same SQLite dataset and the same query shapes. ruprizzle is shown in two configurations: the sqlx backend and the new native rusqlite backend.

Environment

  • Host: Windows 11, local SQLite file
  • Dataset:
    • users: 1,000 rows
    • categories: 20 rows
    • posts: 10,000 rows (10 posts per user)
    • comments: 50,000 rows (5 comments per post)
    • tags: 100 rows
    • post_tags: 30,000 rows (3 tags per post)
    • followers: 5,000 rows
    • likes: 20,000 rows
    • bench_bulk: empty table used for bulk-insert tests
  • Versions:
    • ruprizzle 1.0.0 (this repo; pre-release snapshot — the published 1.5.1 shares this code path but these numbers were not re-run for it)
    • prax-orm 0.11
    • Sea-ORM 1.1
    • Diesel 2.2
    • Prisma 6.19.3
    • Drizzle ORM 0.43.0
    • better-sqlite3 13.0.3
    • rusqlite 0.32.1

Important: this run used SQLite because no Postgres / Docker was available. The numbers are therefore dominated as much by driver choice as by the ORM layer. ruprizzle (sqlx backend) uses sqlx::Any, ruprizzle (rusqlite backend) offloads the synchronous rusqlite call to tokio::task::spawn_blocking so it does not pin the async runtime's worker threads, prax and Sea-ORM use sqlx-sqlite, Diesel uses libsqlite3-sys/diesel with a bundled SQLite, Drizzle uses the synchronous better-sqlite3 binding, and Prisma uses its in-process Rust query engine.

Harness and raw data

  • ruprizzle: crates/runtime/examples/cross_orm_bench.rs
  • ruprizzle (rusqlite): same example with RUST_BENCH_DRIVER=rusqlite
  • prax: local/cross-orm-bench/rust/prax-bench/src/main.rs
  • Sea-ORM: local/cross-orm-bench/rust/sea-orm-bench/src/main.rs
  • Diesel: local/cross-orm-bench/rust/diesel-bench/src/main.rs
  • Prisma / Drizzle: local/cross-orm-bench/node/
  • Database: local/cross-orm-bench/node/bench.sqlite3
  • Result JSONs:
    • local/cross-orm-bench/raw_results.json — all measured trials
    • local/cross-orm-bench/results.json — aggregated statistics
    • local/cross-orm-bench/BENCHMARKS.log — human-readable summary
    • local/cross-orm-bench/node/ruprizzle-results.json
    • local/cross-orm-bench/node/ruprizzle-rusqlite-results.json
    • local/cross-orm-bench/node/prax-results.json
    • local/cross-orm-bench/node/sea-orm-results.json
    • local/cross-orm-bench/node/diesel-results.json
    • local/cross-orm-bench/node/prisma-results.json
    • local/cross-orm-bench/node/drizzle-results.json

End-to-end results

All times are microseconds per operation (lower is better).

Operationruprizzle (sqlx)ruprizzle (rusqlite)praxsea-ormdieselprismadrizzle
select_by_pk25.13.117.966.89.9173.139.0
find_many_10001,634.4386.3741.91,559.1305.42,820.7409.9
find_filtered_ordered1,797.4565.4925.61,603.9425.33,225.3504.7
include_posts21,139.97,553.310,741.220,856.53,627.040,867.0188,946.9
bulk_insert_10001,912.41,383.11,059.06,027.36,689.714,142.59,069.6

Query construction (no I/O)

Operationruprizzle (sqlx)ruprizzle (rusqlite)praxsea-ormdieselprismadrizzle
to_sql_select_by_pk0.70.70.47.60.7—11.6
to_sql_select_filter_order1.71.71.112.31.0—17.1

Codegen / build-step comparison

  • Drizzle: no code generation; the schema is plain TypeScript.
  • ruprizzle: 50-model schema generation = 17.8 ms (cargo bench -p ruprizzle-codegen).
  • Prisma: prisma generate for the 3-model benchmark schema took ~36 ms; it scales linearly with schema size and is heavier than ruprizzle for large schemas.

Analysis

Simple reads

The synchronous, native-driver ORMs lead here:

  • Diesel: 9.9 µs
  • ruprizzle (rusqlite): 3.1 µs
  • prax: 17.9 µs
  • ruprizzle (sqlx): 25.1 µs
  • Drizzle: 39.0 µs
  • Sea-ORM: 66.8 µs
  • Prisma: 173.1 µs

The rusqlite query is offloaded to tokio::task::spawn_blocking, which adds a small dispatch overhead per call while keeping async worker threads unblocked. ruprizzle (rusqlite) is now the fastest on single-row PK lookups for this run. Direct ToSql impls on Value avoid the extra string clone that used to happen per bind. Diesel and ruprizzle (sqlx) are the next tier.

Multi-row and filtered reads

Diesel is still fastest, but ruprizzle (rusqlite) is now within striking distance:

  • find_many_1000: 305.4 µs (Diesel) vs 386.3 µs (ruprizzle rusqlite) vs 409.9 µs (Drizzle) vs 741.9 µs (prax) vs 1,559.1 µs (Sea-ORM) vs 2,820.7 µs (Prisma)
  • find_filtered_ordered: 425.3 µs (Diesel) vs 504.7 µs (Drizzle) vs 565.4 µs (ruprizzle rusqlite) vs 925.6 µs (prax) vs 1,603.9 µs (Sea-ORM) vs 3,225.3 µs (Prisma)

The remaining gap on multi-row reads is mostly per-row decoding overhead in ruprizzle's intermediate Row/FromValue path. The native drivers avoid the per-row async worker-thread hop used by sqlx-sqlite, which still shows up clearly in Sea-ORM and ruprizzle (sqlx).

Relation includes

Diesel's manually-written join query is fastest, while ruprizzle's auto-batched loader remains the strongest automatic option:

  • Diesel: 3.6 ms (manual join)
  • ruprizzle (rusqlite): 7.6 ms (auto-batched)
  • prax: 10.7 ms
  • ruprizzle (sqlx): 21.1 ms
  • Sea-ORM: 20.9 ms
  • Prisma: 40.9 ms
  • Drizzle: 188.9 ms (correlated subquery per parent row)

Offloading the synchronous rusqlite call to spawn_blocking adds a small per-call and per-row overhead compared to running it synchronously on the caller, but it prevents long-running workloads from pinning tokio worker threads. The remaining gap vs Diesel is the in-memory grouping of 10,000 child rows into 1,000 parent Vecs. Diesel does not group in this benchmark. Drizzle's SQLite relational query still emits a correlated subquery with json_group_array per parent row.

Bulk insert

The rusqlite and sqlx backends are fastest:

  • prax: 1.1 ms
  • ruprizzle (rusqlite): 1.4 ms
  • ruprizzle (sqlx): 1.9 ms
  • Sea-ORM: 6.0 ms
  • Diesel: 6.7 ms
  • Drizzle: 9.1 ms
  • Prisma: 14.1 ms

Diesel's bulk insert is slower here despite using a single INSERT statement. ruprizzle and prax both use a multi-value statement with RETURNING * and still come out ahead.

Query construction

Turning a builder into SQL+binds is cheap for all the Rust ORMs, while the TypeScript/JavaScript ORMs are an order of magnitude slower:

  • prax: 0.4 µs, Diesel: 0.7 µs, ruprizzle (rusqlite): 0.7 µs, ruprizzle (sqlx): 0.7 µs
  • Sea-ORM: 7.6–12.3 µs
  • Drizzle: 11.6–17.1 µs
  • Prisma: not exposed

Query construction remains a sub-microsecond win for the Rust ORMs; the bigger wins in this round came from removing per-query SQL string clones and moving the soak harness onto the native rusqlite pool.

Usage criteria

CriterionBest choiceWhy
Compile-time type safety, generated typed clientDiesel or ruprizzleBoth are schema-first and fully typed; Diesel has the larger ecosystem, ruprizzle the more ergonomically generated client.
Maximum simple-query throughput on SQLiteruprizzle (rusqlite)3.1 µs on select_by_pk — ahead of Diesel's 9.9 µs — with spawn_blocking dispatch overhead.
Multi-row reads and filtered queries on SQLiteDiesel, then ruprizzle (rusqlite)Diesel is fastest; ruprizzle (rusqlite) is within 20–40% and beats Drizzle/prax.
Bulk inserts on SQLiteprax, then ruprizzle (rusqlite)1.1–1.4 ms, faster than Diesel/Sea-ORM/Drizzle.
Nested relation loading, automatic batchingDiesel (manual), then ruprizzle (rusqlite), then praxDiesel's manual join is fastest; ruprizzle's auto-batched loader beats Sea-ORM/Prisma.
TypeScript ecosystem, migrations, team familiarityPrismaLargest community, mature migrations, schema-first.
Zero build-step / runtime schemaDrizzleSchema is plain TypeScript, no code generation.
SQL transparency / .to_sql() on every builderruprizzle, Diesel, or Drizzleruprizzle and Diesel expose SQL cheaply; Drizzle exposes it too but is slower to construct.
Production Postgresruprizzle, Prisma, or Dieselruprizzle's performance.md shows it within ~5% of hand-written sqlx on Postgres; Diesel and Drizzle are also strong on Postgres but were not measured here.

Caveats

  1. SQLite is not Postgres. These numbers are from a single SQLite file. The relative ordering can change with network latency, a different driver, or a different database. Do not cite these numbers for a Postgres comparison until they are re-run on Postgres.
  2. Driver and dispatch differences dominate simple reads. ruprizzle (rusqlite) offloads rusqlite queries to tokio::task::spawn_blocking, trading a small per-call dispatch cost for the ability to keep the async runtime responsive. ruprizzle (rusqlite) wins on single-row PK lookups for this run, with Diesel close behind running the native SQLite call synchronously on the caller. Diesel uses libsqlite3-sys directly, and Drizzle uses the synchronous better-sqlite3 binding. All of these avoid the per-row async worker-thread hop used by sqlx-sqlite (which powers ruprizzle (sqlx), prax, and Sea-ORM). The measured row-hop cost is roughly 0.9 µs/row for sqlx-sqlite versus ~0.3 µs/row for the synchronous bindings, which is why Diesel, ruprizzle (rusqlite), and Drizzle cluster near the top for simple reads.
  3. Drizzle relational query is SQLite/driver-specific. On Postgres Drizzle can use joins/CTEs and would likely be far faster for include_posts; do not take the 188.9 ms as a universal Drizzle number.
  4. No network. All ORMs talked to a local file, so result-set decoding and ORM overhead are the main differentiators.
  5. This run used 1 warm-up + 10 measured trials per driver. Medians are reported. See local/cross-orm-bench/BENCHMARKS.log and local/cross-orm-bench/raw_results.json for full per-trial data. Run-to-run variance can be 5–10% on Windows. The main take-away is the relative shape between backends, not single-digit absolute values.

See also

  • Performance — Postgres vs sqlx measurements and the sqlx::Any text-marshalling note.
  • Known limitations — honest boundaries of the alpha.
  • Feature master comparison — feature and architecture comparison across all ORMs, including the extended benchmark table.
  • ProjectPlan/ImplementationPlan/ImplPlan09TestingRelease.md — original testing-and-benchmark plan.

Benchmark run: 2026-08-13 07:25 UTC

Environment

  • Warm-up trials: 1
  • Measured trials: 2
  • Dataset:
    • 1,000 users
    • 20 categories
    • 10,000 posts
    • 50,000 comments
    • 100 tags
    • 30,000 post_tags
    • 5,000 followers
    • 20,000 likes

End-to-end results

All times are microseconds per operation (lower is better).

Operationruprizzle (sqlx)ruprizzle (rusqlite)praxsea-ormdieselprismadrizzle
select_by_pk24.03.124.783.711.2196.750.8
find_many_10001,725.2367.5731.31,641.7306.92,844.8461.6
find_filtered_ordered1,767.5566.3880.51,648.0413.13,351.1585.5
find_filtered_paginated404.1298.5350.0421.9307.8717.8375.7
find_in_list114.228.4125.3131.437.7434.4143.5
find_complex_filter331.9157.9302.0337.4158.1905.1258.0
count_filtered46.120.551.685.126.8203.862.9
exists_filtered31.42.644.457.19.6152.059.2
include_posts22,034.97,133.611,112.620,362.43,845.743,635.5202,045.1
include_author21,274.47,341.28,882.520,066.13,305.285,683.719,261.1
include_posts_and_comments134,962.355,612.443,914.9110,351.220,711.9260,752.610,445,301.8
include_posts_with_tags54,808.525,538.126,189.554,337.68,326.9265,723.746,585.6
find_popular_posts1,471.41,253.01,980.71,616.61,295.72,590.96,567.2
bulk_insert_10001,907.81,238.31,139.96,456.86,765.014,355.79,612.8

Query construction (no I/O)

Operationruprizzle (sqlx)ruprizzle (rusqlite)praxsea-ormdieselprismadrizzle
to_sql_select_by_pk0.50.60.47.80.7—11.4
to_sql_select_filter_order1.51.51.112.41.0—16.4
to_sql_select_in_list2.32.34.328.42.7—38.3
to_sql_select_complex_filter1.81.81.514.61.1—19.0
to_sql_select_paginated1.51.51.111.91.0—19.2

Benchmark run: 2026-08-13 11:45 UTC

Environment

  • Warm-up trials: 1
  • Measured trials: 3
  • Dataset:
    • 1,000 users
    • 20 categories
    • 10,000 posts
    • 50,000 comments
    • 100 tags
    • 30,000 post_tags
    • 5,000 followers
    • 20,000 likes

End-to-end results

All times are microseconds per operation (lower is better).

Operationruprizzle (sqlx)ruprizzle (rusqlite)praxsea-ormdieselprismadrizzle
select_by_pk25.43.020.563.210.0209.838.1
find_many_10001,648.4375.9737.51,641.6296.83,078.2405.6
find_filtered_ordered1,882.6556.7900.51,618.2413.33,465.3539.6
find_filtered_paginated392.6297.0353.6421.1304.1801.8361.1
find_in_list115.130.298.6131.237.6481.9130.0
find_complex_filter306.9163.8232.3352.8159.2873.4234.0
count_filtered35.521.540.377.525.7203.751.6
exists_filtered16.52.616.957.79.6159.744.5
include_posts21,069.97,185.710,711.719,915.23,743.742,498.5186,426.8
include_author20,702.47,231.69,064.720,774.23,438.083,394.216,330.6
include_posts_and_comments131,291.156,928.343,907.2108,491.820,990.9262,741.69,093,560.6
include_posts_with_tags51,677.926,213.626,020.851,054.78,071.8257,371.436,273.0
find_popular_posts1,506.31,306.02,021.41,620.31,297.82,547.25,556.0
bulk_insert_10001,865.91,273.51,102.56,171.27,060.813,761.89,778.8

Query construction (no I/O)

Operationruprizzle (sqlx)ruprizzle (rusqlite)praxsea-ormdieselprismadrizzle
to_sql_select_by_pk0.60.50.47.30.7—11.6
to_sql_select_filter_order1.51.61.112.11.0—17.0
to_sql_select_in_list2.42.34.324.92.7—38.8
to_sql_select_complex_filter1.81.91.514.21.1—18.8
to_sql_select_paginated1.51.51.111.71.0—17.2

Benchmark run: 2026-08-17 10:31 UTC

Environment

  • Warm-up trials: 1
  • Measured trials: 3
  • Dataset:
    • 1,000 users
    • 20 categories
    • 10,000 posts
    • 50,000 comments
    • 100 tags
    • 30,000 post_tags
    • 5,000 followers
    • 20,000 likes

End-to-end results

All times are microseconds per operation (lower is better).

Operationruprizzle (sqlx)ruprizzle (rusqlite)praxsea-ormdieselprismadrizzle
select_by_pk26.83.224.568.410.5205.540.6
find_many_10001,672.0421.8737.91,685.6303.62,929.8445.3
find_filtered_ordered1,820.5588.5867.51,664.3458.03,364.7592.5
find_filtered_paginated380.8323.0367.2425.3313.9688.5383.7
find_in_list107.630.493.5130.338.0443.8153.2
find_complex_filter317.9169.4254.2351.6161.2847.0281.9
count_filtered36.119.838.781.126.7200.951.6
exists_filtered19.02.728.761.39.6184.448.5
include_posts22,552.88,064.811,167.220,926.73,740.344,188.7209,266.2
include_author22,017.37,805.19,258.220,993.03,563.987,114.521,389.2
include_posts_and_comments139,103.659,680.645,911.1116,811.122,209.8271,459.59,939,872.7
include_posts_with_tags58,117.228,041.026,128.755,850.48,884.1282,784.339,234.7
find_popular_posts1,504.41,376.11,980.91,639.01,414.52,686.26,129.3
prepared_select_by_pk20.42.4—————
stream_find_many_10001,922.2704.1—————
bulk_insert_10002,100.21,502.01,044.014,892.67,632.813,908.49,867.8

Query construction (no I/O)

Operationruprizzle (sqlx)ruprizzle (rusqlite)praxsea-ormdieselprismadrizzle
to_sql_select_by_pk0.60.60.47.60.8—12.3
to_sql_select_filter_order1.51.51.112.21.0—18.0
to_sql_select_in_list2.32.34.526.12.8—41.8
to_sql_select_complex_filter1.81.81.614.31.2—20.9
to_sql_select_paginated1.51.61.111.71.0—18.9
to_sql_prepared_select_by_pk0.60.7—————
prepared_rebind_select_by_pk0.00.0—————
to_sql_conditional_filter0.80.8—————
to_sql_select_with_cte1.61.6—————
to_sql_select_with_recursive_cte2.32.4—————
to_sql_set_union1.61.4—————
to_sql_select_with_join0.90.9—————
to_sql_select_exists_subquery1.01.1—————
to_sql_select_in_subquery1.31.4—————
to_sql_nested_insert1.21.2—————
to_sql_nested_update0.80.8—————

Benchmark run: 2026-08-17 12:00 UTC

Environment

  • Warm-up trials: 1
  • Measured trials: 3
  • Dataset:
    • 1,000 users
    • 20 categories
    • 10,000 posts
    • 50,000 comments
    • 100 tags
    • 30,000 post_tags
    • 5,000 followers
    • 20,000 likes

End-to-end results

All times are microseconds per operation (lower is better).

Operationruprizzle (sqlx)ruprizzle (rusqlite)praxsea-ormdieselprismadrizzle
select_by_pk20.93.117.666.510.1174.839.3
find_many_10001,620.4424.2794.71,710.1303.82,879.6406.8
find_filtered_ordered1,841.1549.2925.31,810.3421.83,332.9480.2
find_filtered_paginated393.1309.0347.4472.9307.7667.1372.6
find_in_list107.132.880.8131.841.4445.1104.8
find_complex_filter310.3156.7230.3355.2167.2836.1248.4
count_filtered35.519.534.989.925.4187.046.7
exists_filtered17.12.616.158.69.5155.946.1
include_posts22,514.67,411.610,818.122,010.83,725.542,982.6189,412.7
include_author21,994.27,115.18,845.521,775.03,417.683,281.317,031.6
include_posts_and_comments137,868.357,814.543,439.2118,143.120,724.0262,781.59,280,171.7
include_posts_with_tags55,864.726,187.525,400.958,378.98,063.9266,997.037,587.5
find_popular_posts1,518.61,306.81,993.91,661.41,324.32,646.55,636.3
prepared_select_by_pk18.22.64.563.79.9177.014.9
stream_find_many_10002,024.0689.757.72,760.6237.32,643.1314.8
bulk_insert_10001,966.01,434.71,195.36,279.67,080.613,614.58,518.1

Query construction (no I/O)

Operationruprizzle (sqlx)ruprizzle (rusqlite)praxsea-ormdieselprismadrizzle
to_sql_select_by_pk0.60.60.47.50.70.111.8
to_sql_select_filter_order1.51.51.112.71.00.117.2
to_sql_select_in_list2.32.34.425.32.70.739.6
to_sql_select_complex_filter1.81.81.514.31.10.119.4
to_sql_select_paginated1.51.51.112.01.00.117.7
to_sql_prepared_select_by_pk0.60.60.42.70.80.111.8
prepared_rebind_select_by_pk0.00.00.10.10.20.10.1
to_sql_conditional_filter0.80.80.48.30.80.315.0
to_sql_select_with_cte1.61.60.815.80.20.136.1
to_sql_select_with_recursive_cte2.42.40.521.30.30.10.1
to_sql_set_union1.41.40.914.01.10.126.4
to_sql_select_with_join0.90.90.19.21.10.129.2
to_sql_select_exists_subquery1.01.00.115.01.10.123.8
to_sql_select_in_subquery1.41.40.110.60.80.119.0
to_sql_nested_insert1.21.20.40.00.60.119.9
to_sql_nested_update0.80.80.30.00.30.117.6

Benchmark run: 2026-08-17 16:16 UTC

Environment

  • Warm-up trials: 1
  • Measured trials: 10
  • Dataset:
    • 1,000 users
    • 20 categories
    • 10,000 posts
    • 50,000 comments
    • 100 tags
    • 30,000 post_tags
    • 5,000 followers
    • 20,000 likes

End-to-end results

All times are microseconds per operation (lower is better).

Operationruprizzle (sqlx)ruprizzle (rusqlite)praxsea-ormdieselprismadrizzle
select_by_pk22.63.022.965.815.5196.439.2
find_many_10001,644.7383.2770.61,684.5311.23,061.4411.1
find_filtered_ordered1,781.2569.4946.21,777.0446.43,469.7498.7
find_filtered_paginated381.8308.6403.6460.7314.5730.7347.7
find_in_list102.129.6107.3147.853.2463.5100.6
find_complex_filter306.6164.9262.0372.8182.1850.3221.4
count_filtered39.420.044.487.133.7199.447.1
exists_filtered17.32.718.464.613.4166.741.3
include_posts22,236.77,679.711,498.621,707.33,801.745,196.0187,172.4
include_author22,262.87,436.99,581.221,619.03,453.087,424.816,660.2
include_posts_and_comments132,481.457,545.444,265.0117,815.921,704.7270,511.99,144,201.9
include_posts_with_tags55,727.327,186.326,821.057,127.18,494.4274,363.437,185.9
find_popular_posts1,478.61,268.72,160.11,661.81,317.82,689.45,543.8
prepared_select_by_pk26.02.34.674.915.0179.614.9
stream_find_many_10002,035.8686.059.72,485.3245.52,754.3316.6
bulk_insert_10001,962.51,346.01,222.49,403.513,988.213,118.68,341.6

Query construction (no I/O)

Operationruprizzle (sqlx)ruprizzle (rusqlite)praxsea-ormdieselprismadrizzle
to_sql_select_by_pk0.60.60.47.60.70.112.2
to_sql_select_filter_order1.51.61.112.41.00.118.0
to_sql_select_in_list2.32.44.425.42.80.740.6
to_sql_select_complex_filter1.81.81.514.61.20.120.0
to_sql_select_paginated1.51.51.112.01.00.118.4
to_sql_prepared_select_by_pk0.60.60.42.70.80.112.0
prepared_rebind_select_by_pk0.00.00.10.10.20.10.1
to_sql_conditional_filter0.80.80.48.40.90.315.4
to_sql_select_with_cte1.61.60.815.70.20.136.9
to_sql_select_with_recursive_cte2.32.40.521.40.20.10.1
to_sql_set_union1.61.40.914.11.20.127.4
to_sql_select_with_join0.90.90.19.21.10.130.3
to_sql_select_exists_subquery1.01.10.115.11.10.124.3
to_sql_select_in_subquery1.41.40.110.70.80.119.3
to_sql_nested_insert1.21.30.40.00.60.120.6
to_sql_nested_update0.80.80.30.00.30.118.4

Benchmark run: 2026-08-17 16:55 UTC

Environment

  • Warm-up trials: 1
  • Measured trials: 10
  • Dataset:
    • 1,000 users
    • 20 categories
    • 10,000 posts
    • 50,000 comments
    • 100 tags
    • 30,000 post_tags
    • 5,000 followers
    • 20,000 likes

End-to-end results

All times are microseconds per operation (lower is better).

Operationruprizzle (sqlx)ruprizzle (rusqlite)praxsea-ormdieselprismadrizzle
select_by_pk27.93.122.576.810.0182.938.3
find_many_10001,741.1385.8771.01,616.5297.42,935.7414.2
find_filtered_ordered1,918.1569.6966.11,669.8433.83,358.3506.7
find_filtered_paginated412.9312.6371.2426.0307.9666.1360.0
find_in_list125.629.5101.0129.439.9427.7101.9
find_complex_filter324.8166.8256.8343.9172.2838.5229.3
count_filtered39.620.640.781.325.9178.947.7
exists_filtered18.52.719.357.99.8157.742.4
include_posts22,881.27,545.511,712.920,333.53,647.444,300.7186,014.4
include_author23,033.27,332.09,596.420,500.23,362.586,517.416,450.2
include_posts_and_comments136,207.957,665.944,929.0110,745.120,997.0267,560.29,098,301.2
include_posts_with_tags57,895.027,607.227,132.654,141.48,209.3276,963.636,364.1
find_popular_posts1,579.21,268.02,221.21,564.61,296.92,662.85,553.4
prepared_select_by_pk20.52.35.360.210.2165.514.8
stream_find_many_10002,096.7706.558.12,576.9231.72,659.3330.7
bulk_insert_10002,099.71,395.01,174.65,031.36,619.313,236.68,536.1

Query construction (no I/O)

Operationruprizzle (sqlx)ruprizzle (rusqlite)praxsea-ormdieselprismadrizzle
to_sql_select_by_pk0.60.60.47.40.70.111.8
to_sql_select_filter_order1.61.61.212.21.00.117.2
to_sql_select_in_list2.32.44.525.62.70.740.3
to_sql_select_complex_filter1.81.91.614.21.10.119.1
to_sql_select_paginated1.51.51.111.81.00.117.7
to_sql_prepared_select_by_pk0.60.60.42.70.70.111.7
prepared_rebind_select_by_pk0.00.00.10.10.20.10.1
to_sql_conditional_filter0.80.80.48.30.80.314.6
to_sql_select_with_cte1.61.60.815.30.20.135.6
to_sql_select_with_recursive_cte2.32.40.520.80.20.10.1
to_sql_set_union1.61.40.913.71.10.126.0
to_sql_select_with_join0.90.90.19.01.10.129.0
to_sql_select_exists_subquery1.01.10.114.41.10.124.0
to_sql_select_in_subquery1.41.40.110.50.80.118.6
to_sql_nested_insert1.21.20.40.00.50.119.8
to_sql_nested_update0.80.80.30.00.30.117.4

Benchmark run: 2026-08-18 06:04 UTC

Environment

  • Warm-up trials: 1
  • Measured trials: 10
  • Concurrency levels: [1, 10, 100]
  • Duration per throughput run: 5.0s
  • Dataset:
    • 1,000 users
    • 20 categories
    • 10,000 posts
    • 50,000 comments
    • 100 tags
    • 30,000 post_tags
    • 5,000 followers
    • 20,000 likes

End-to-end results

All times are microseconds per operation (lower is better).

Operationruprizzle (sqlx)ruprizzle (rusqlite)praxsea-ormdieselprismadrizzle
select_by_pk25.13.117.966.89.9173.139.0
find_many_10001,634.4386.3741.91,559.1305.42,820.7409.9
find_filtered_ordered1,797.4565.4925.61,603.9425.33,225.3504.7
find_filtered_paginated386.1300.0361.7455.4307.9629.8357.0
find_in_list107.730.098.8130.739.6404.299.0
find_complex_filter314.2162.1251.8340.4164.2774.0228.6
count_filtered40.120.344.491.325.7170.145.8
exists_filtered20.72.722.170.09.6151.441.6
include_posts21,139.97,553.310,741.220,856.53,627.040,867.0188,946.9
include_author20,764.97,122.68,779.820,716.53,285.478,985.716,595.5
include_posts_and_comments131,693.459,759.241,534.5114,364.320,605.2251,942.49,214,149.0
include_posts_with_tags54,108.528,362.624,896.254,784.98,156.6280,121.637,234.5
find_popular_posts1,458.41,266.32,058.71,671.51,275.62,805.25,655.4
prepared_select_by_pk24.62.34.984.710.0194.214.9
stream_find_many_10002,296.3705.657.11,807.1225.63,290.1327.0
bulk_insert_10001,912.41,383.11,059.06,027.36,689.714,142.59,069.6

Query construction (no I/O)

Operationruprizzle (sqlx)ruprizzle (rusqlite)praxsea-ormdieselprismadrizzle
to_sql_select_by_pk0.70.70.47.60.70.111.6
to_sql_select_filter_order1.71.71.112.31.00.117.1
to_sql_select_in_list2.52.54.325.82.70.739.4
to_sql_select_complex_filter2.02.01.514.31.10.119.8
to_sql_select_paginated1.71.71.111.81.00.118.2
to_sql_prepared_select_by_pk0.70.70.42.70.80.111.9
prepared_rebind_select_by_pk0.00.00.10.10.20.10.1
to_sql_conditional_filter1.01.00.49.10.80.315.3
to_sql_select_with_cte1.91.90.819.10.20.136.5
to_sql_select_with_recursive_cte2.82.80.525.60.20.10.1
to_sql_set_union1.81.60.917.11.10.127.3
to_sql_select_with_join1.01.00.111.41.10.130.1
to_sql_select_exists_subquery1.31.30.118.01.10.124.3
to_sql_select_in_subquery1.71.70.113.10.80.119.1
to_sql_nested_insert1.31.40.40.00.60.120.3
to_sql_nested_update0.91.00.30.00.30.117.6

Latency percentiles (ruprizzle sqlx)

Operationp50p95p99
select_by_pk25.132.533.5
find_many_10001,634.41,701.21,725.8
find_filtered_ordered1,797.41,863.11,863.7
find_filtered_paginated386.1407.9408.7
find_in_list107.7122.2125.4
find_complex_filter314.2338.3342.2
count_filtered40.148.249.8
exists_filtered20.730.833.0
include_posts21,139.923,082.523,460.9
include_author20,764.921,973.522,057.2
include_posts_and_comments131,693.4138,897.9139,415.8
include_posts_with_tags54,108.557,747.557,792.9
find_popular_posts1,458.41,482.61,484.6
prepared_select_by_pk24.632.332.7
stream_find_many_10002,296.32,385.92,397.2
bulk_insert_10001,912.42,980.83,497.2
to_sql_select_by_pk0.70.70.7
to_sql_select_filter_order1.71.71.8
to_sql_select_in_list2.52.52.6
to_sql_select_complex_filter2.02.12.2
to_sql_select_paginated1.71.81.9
to_sql_prepared_select_by_pk0.70.70.7
prepared_rebind_select_by_pk0.00.00.0
to_sql_conditional_filter1.01.01.0
to_sql_select_with_cte1.91.91.9
to_sql_select_with_recursive_cte2.82.92.9
to_sql_set_union1.81.81.8
to_sql_select_with_join1.01.01.0
to_sql_select_exists_subquery1.31.41.4
to_sql_select_in_subquery1.71.71.7
to_sql_nested_insert1.31.41.4
to_sql_nested_update0.91.01.0

Throughput (ops/sec)

BackendConcurrencyselect_by_pkfind_many_1000bulk_insert_1000

Benchmark run: 2026-08-31 13:17 UTC

Environment

  • Warm-up trials: 1
  • Measured trials: 10
  • Concurrency levels: [1, 10, 100]
  • Duration per throughput run: 5.0s
  • Dataset:
    • 1,000 users
    • 20 categories
    • 10,000 posts
    • 50,000 comments
    • 100 tags
    • 30,000 post_tags
    • 5,000 followers
    • 20,000 likes

End-to-end results

All times are microseconds per operation (lower is better).

Operationruprizzle (sqlx)ruprizzle (rusqlite)praxsea-ormdieselprismadrizzle
select_by_pk25.13.117.966.89.9173.139.0
find_many_10001,634.4386.3741.91,559.1305.42,820.7409.9
find_filtered_ordered1,797.4565.4925.61,603.9425.33,225.3504.7
find_filtered_paginated386.1300.0361.7455.4307.9629.8357.0
find_in_list107.730.098.8130.739.6404.299.0
find_complex_filter314.2162.1251.8340.4164.2774.0228.6
count_filtered40.120.344.491.325.7170.145.8
exists_filtered20.72.722.170.09.6151.441.6
include_posts21,139.97,553.310,741.220,856.53,627.040,867.0188,946.9
include_author20,764.97,122.68,779.820,716.53,285.478,985.716,595.5
include_posts_and_comments131,693.459,759.241,534.5114,364.320,605.2251,942.49,214,149.0
include_posts_with_tags54,108.528,362.624,896.254,784.98,156.6280,121.637,234.5
find_popular_posts1,458.41,266.32,058.71,671.51,275.62,805.25,655.4
prepared_select_by_pk24.62.34.984.710.0194.214.9
stream_find_many_10002,296.3705.657.11,807.1225.63,290.1327.0
bulk_insert_10001,912.41,383.11,059.06,027.36,689.714,142.59,069.6

Query construction (no I/O)

Operationruprizzle (sqlx)ruprizzle (rusqlite)praxsea-ormdieselprismadrizzle
to_sql_select_by_pk0.70.70.47.60.70.111.6
to_sql_select_filter_order1.71.71.112.31.00.117.1
to_sql_select_in_list2.52.54.325.82.70.739.4
to_sql_select_complex_filter2.02.01.514.31.10.119.8
to_sql_select_paginated1.71.71.111.81.00.118.2
to_sql_prepared_select_by_pk0.70.70.42.70.80.111.9
prepared_rebind_select_by_pk0.00.00.10.10.20.10.1
to_sql_conditional_filter1.01.00.49.10.80.315.3
to_sql_select_with_cte1.91.90.819.10.20.136.5
to_sql_select_with_recursive_cte2.82.80.525.60.20.10.1
to_sql_set_union1.81.60.917.11.10.127.3
to_sql_select_with_join1.01.00.111.41.10.130.1
to_sql_select_exists_subquery1.31.30.118.01.10.124.3
to_sql_select_in_subquery1.71.70.113.10.80.119.1
to_sql_nested_insert1.31.40.40.00.60.120.3
to_sql_nested_update0.91.00.30.00.30.117.6

Latency percentiles (ruprizzle sqlx)

Operationp50p95p99
select_by_pk25.132.533.5
find_many_10001,634.41,701.21,725.8
find_filtered_ordered1,797.41,863.11,863.7
find_filtered_paginated386.1407.9408.7
find_in_list107.7122.2125.4
find_complex_filter314.2338.3342.2
count_filtered40.148.249.8
exists_filtered20.730.833.0
include_posts21,139.923,082.523,460.9
include_author20,764.921,973.522,057.2
include_posts_and_comments131,693.4138,897.9139,415.8
include_posts_with_tags54,108.557,747.557,792.9
find_popular_posts1,458.41,482.61,484.6
prepared_select_by_pk24.632.332.7
stream_find_many_10002,296.32,385.92,397.2
bulk_insert_10001,912.42,980.83,497.2
to_sql_select_by_pk0.70.70.7
to_sql_select_filter_order1.71.71.8
to_sql_select_in_list2.52.52.6
to_sql_select_complex_filter2.02.12.2
to_sql_select_paginated1.71.81.9
to_sql_prepared_select_by_pk0.70.70.7
prepared_rebind_select_by_pk0.00.00.0
to_sql_conditional_filter1.01.01.0
to_sql_select_with_cte1.91.91.9
to_sql_select_with_recursive_cte2.82.92.9
to_sql_set_union1.81.81.8
to_sql_select_with_join1.01.01.0
to_sql_select_exists_subquery1.31.41.4
to_sql_select_in_subquery1.71.71.7
to_sql_nested_insert1.31.41.4
to_sql_nested_update0.91.01.0