MongoDB + Redis Performance Audit

Database performance benchmarks with trend analysis and competitive context.

7/4/2026

32 min read

Note

Competitive comparisons based on publicly available documentation as of June 2026. All SveltyCMS metrics self-measured via bun test tests/benchmarks/.

Important

Console-only by default. Use BENCHMARK_RECORD=1 to write results to this report.

BENCHMARK_RECORD=1 bun test tests/benchmarks/auth-performance.test.ts

The full matrix runner (bun run scripts/benchmark-matrix/index.ts --sql) always records.

📊 Latest Performance Audit

📝 Fix Overlays

Note

Phase notes and remediation entries appear here after matrix or surgical runs.

(06/10/2026, 14:48:32)

✅ PASS · 19/39 tests · 20 skipped · MONGODB+REDIS · Bun 1.4.2

Dimension health

Dimension	Tests	Status	Worst Δ
Core	10	🟢	+511%
API	9	🟢	+92%
Scale	15	🟢	+113%
Resilience	5	🟢	—

Issues (action required)

✅ All clear — no regressions or budget violations detected.

Executive latency matrix

Scenario	Latency	Trend	Budget	Result
Cold Start	N/A	⚪ (—)	< 5000ms	⚪ N/A
REST (Collections)	N/A	⚪ (—)	< 5ms	⚪ N/A
Middleware Hooks	N/A	⚪	< 2ms	⚪ N/A
GraphQL (Avg)	N/A	⚪ (—)	< 5ms	⚪ N/A
Million-Row Index	N/A	⚪	< 250ms	⚪ N/A
DB Raw (p95)	N/A	⚪	< 50ms	⚪ N/A

Historical pulse

Scope: Sparklines only — full run tables: tests/benchmarks/results/history.sqlite

Metric	Trend	Sparkline	Latest

📈 Latency trend chart (last 10 runs)

xychart-beta title "MONGODB+REDIS REST p95 (last 10 runs)" x-axis ["R1", "R2", "R3", "R4", "R5", "R6", "R7", "R8", "R9", "R10"] y-axis "Latency (ms)" line "p95" : [0.000, 0.000, 0.000, 0.000, 0.000, 0.000, 0.000, 0.000, 0.000, 0.000]

📊 Regression severity matrix (quadrant)

quadrantChart title "Regression severity (impact vs delta)" x-axis Low latency impact --> High latency impact y-axis Low delta --> High delta quadrant-1 Monitor quadrant-2 Investigate soon quadrant-3 Acceptable variance quadrant-4 Critical — fix first API LAYER LATENCY: [0.06, 0.95] COMPETITIVE 9-WORKLOAD REPLI: [0.05, 0.16] MIDDLEWARE FLAMEGRAPH PROFIL: [0.05, 0.13] Incremental Content Reload: [0.05, 0.29] State Machine Transitions: [0.95, 0.05] Database Adapter Raw CRUD: [0.05, 0.18] REST API Performance: [0.07, 0.18] GraphQL API Performance: [0.05, 0.07]

📋 Partial report — run full matrix for complete cross-DB analysis.

🔴 Top Regressions

🔴 sharp-vs-bun-image [Bun.Image Metadata (header-only)] (mongodb-redis): +127% | 0.01ms vs 0.00ms baseline 🔴 seo-performance [Robots.txt Generation] (mongodb-redis): +32% | 1.61ms vs 1.22ms baseline 🟠 truth-latency [Local SDK (Full)] (mongodb-redis): +20% | 0.01ms vs 0.01ms baseline 🟠 media-performance [Media: Duplicate Upload (identical bytes)] (mongodb-redis): +15% | 7.78ms vs 6.76ms baseline 🟠 api-latency [HTTP: findById TURBO-HIT idle (Warm)] (mongodb-redis): +15% | 0.21ms vs 0.19ms baseline

🟢 Top Improvements

local-cms-crud [LocalCMS findById (Warm)] (mongodb-redis): -50% | 0.00ms vs 0.00ms baseline admin-ux-vitality [Schema Resolution (8f)] (mongodb-redis): -46% | 0.24ms vs 0.46ms baseline scale-spectrum [create @ 100000] (mongodb-redis): -45% | 2.05ms vs 3.75ms baseline index-pressure [Sorted List (25k rows)] (mongodb-redis): -45% | 0.39ms vs 0.70ms baseline scale-spectrum [listFilterSort @ 50000] (mongodb-redis): -43% | 0.63ms vs 1.10ms baseline

Current Run Summary

Only tests that ran in THIS invocation. Populated after BENCHMARK_RECORD=1 or matrix run.

Historical Trends (2026-10-06)

Mode: production-parity matrix runs only (run_mode='matrix' + server_mode='production' — NODE_ENV=production, no TEST_MODE). Standalone/mode-variant samples are recorded but never trended here.

Scope: Sparklines only — full run tables live in history.sqlite (link below). Runs = sparkline bar count.

Detail: tests/benchmarks/results/history.sqlite · SELECT test_id, phase, server_mode, avg_ms, p95_ms, rps, timestamp FROM runs WHERE db_type='mongodb' AND redis=1 ORDER BY timestamp DESC

Series: 56 · DB: mongodb-redis

Metric	Trend	Sparkline (last 7)	Latest
ADMIN UX VITALITY (warm)	🟢	`█▂▇▁`	0.244ms
AI PERFORMANCE (warm)	🟢	`▁▁▁▁`	0.000ms
API LATENCY (warm)	🟢	`▁▆█▂▁▁▆`	1.816ms
AUTH PERFORMANCE (warm)	🟢	`▄▄▁▄█▄▄`	0.797ms
AUTH SESSION AMR (warm)	🟢	`█▅▆▂▃▁▃`	0.696ms
BUILD ANALYSIS (warm)	🟢	`▁▁`	0.000ms
CACHE HIT RATIO (warm)	🟢	`▂▁█▅▁▁▇`	1.405ms
CACHE PERFORMANCE (warm)	🟢	`▂█▁▇`	0.857ms
CACHE SERVICE (warm)	🟢	`▁▄█▁▄▆`	0.717ms
CLIENT JOURNEY (warm)	🟢	`█▁`	3.470ms
COMPETITIVE WORKLOAD REPLICA (warm)	🟢	`▁▁▁▃▂█▃`	1.271ms
CONCURRENCY MAX (warm)	🟢	`█▁`	69.379ms
CONTENT GUI SAVE (warm)	🟢	`█▁`	1.366ms
CONTENT SCALE STRESS (warm)	🟢	`█▁▇▁`	0.146ms
CONTENT SCAN (warm)	🟢	`█▂▇▁`	0.671ms
DATABASE PERFORMANCE (warm)	🟢	`▁▃██▁▁▂`	1.302ms
EDGE SYNC (warm)	🟢	`█▁`	2.680ms
ENTRY EDIT HYDRATION (warm)	🟢	`▁▁▆█▁▁▆`	0.017ms
GRAPHQL API PERFORMANCE (warm)	🟢	`▁▅▄█▆▁▁`	0.740ms
GRAPHQL CACHE HIT (warm)	🟢	`▂▅▁█▁▄▁`	1.082ms
GRAPHQL LOCAL SDK (warm)	🟢	`█▁█▁`	0.000ms
GRAPHQL STRESS (warm)	🟢	`█▁▂▃▁▅▇`	9.302ms
HOOKS PERFORMANCE (warm)	🟢	`▄▄▁█▁▅▃`	0.619ms
INDEX PRESSURE (warm)	🟢	`▄█▁▂`	0.387ms
LARGE PAYLOAD STREAMING (warm)	🟢	`▂▆█▁▂▆█`	14.188ms
LOCAL API PERFORMANCE (warm)	🟢	`█▆▁▇██`	0.633ms
LOCAL API THROUGHPUT (warm)	🟢	`█▂▆▁`	2.395ms
LOCAL CMS CRUD (warm)	🟢	`▃▃▃▃▁█▄`	0.819ms
LOCAL SDK VS DIRECT (warm)	🟢	`▁▆▁▅▂▇█`	0.771ms
MEDIA PERFORMANCE (warm)	🟢	`▁▆▁▄▂▂█`	99.812ms
MEDIA UPLOAD STRESS (warm)	🟢	`▁█▁▂`	7.117ms
MEMORY COUNTERS (warm)	🟢	`▁▁`	0.000ms
MIDDLEWARE FLAMEGRAPH (warm)	🟢	`▄▅▃█▁▁█`	1.311ms
MIGRATION SCALE (warm)	🟢	`█▂▁▇▁▁`	0.512ms
MIXED WORKLOAD (warm)	🟢	`█▁`	0.752ms
MULTI TENANT PERFORMANCE (warm)	🟢	`█▁`	0.545ms
OPENAPI PERFORMANCE (warm)	🟢	`▆▁█▆▁▇`	1.278ms
PRODUCTION DAY (warm)	🟢	`█▁`	1.528ms
REALTIME PERFORMANCE (warm)	🟢	`▁▁▁▁▁▁`	0.000ms
REST API PERFORMANCE (warm)	🟢	`▃▇▂▁▃▁█`	1.989ms
REVISION STRESS (warm)	🟢	`▂█▂▁▇▁`	0.291ms
RIGHT TO BE FORGOTTEN AUDIT (warm)	🟢	`█▁`	6.501ms
SCALE SPECTRUM (warm)	🟢	`█▅▂▅▃▁▁`	0.629ms
SECURITY AUDIT (warm)	🟢	`█▁▁▁▁▁▁`	0.001ms
SEO PERFORMANCE (warm)	🟢	`█▁▁▁▇▁▁`	1.614ms
SHARP VS BUN IMAGE (warm)	🟢	`▅▅▁▁▂██`	49.504ms
STATE MACHINE TRANSITION (warm)	🟢	`▅█▅▁`	28.154ms
TELEMETRY PERFORMANCE (warm)	🟢	`█▁█▁`	0.000ms
TEMPORAL INTEGRITY (warm)	🟢	`█▁`	2.951ms
TRANSACTION ACID (warm)	🟢	`▁█▁█`	0.648ms
TRUTH LATENCY (warm)	🟢	`▃▁▁█▃▁▁`	0.000ms
WEBSOCKET BROADCAST (warm)	🟢	`█▁`	0.138ms
WIDGET PERFORMANCE (warm)	🟢	`█▁▆█▁▆`	0.544ms
CONFIG PROMOTION (warm)	⚪	`▃▅▆▅█▁▁`	6.115ms
CONTENT INCREMENTAL RELOAD (warm)	⚪	`▃▁█▃▂▁▆`	0.550ms
NEGATIVE CACHE (warm)	⚪	`▇▇▁▇█▁`	0.001ms

📊 Infrastructure drill-down (expand for adapter, hooks, memory trends)

📊 Infrastructure drill-down

🏷️ Mixed Workload Performance {#mixedAvg}

Mixed p95: — (not measured in this run) | Trend: ⚪ (—)

Production request mix: 60% Reads, 20% Writes, 15% GraphQL, 5% Media.

🏷️ Database Adapter Performance {#dbRaw}

Raw Adapter p95: — (not measured in this run) | Target: < 50ms | Trend: ⚪ (—)

Direct database access latency (bypass CMS logic).

🏷️ Middleware & Hooks Audit {#hooks}

Middleware p95: — (not measured in this run) | Target: < 2ms | Trend: ⚪ (—)

Total overhead of security, logging, and auth hooks.

🏷️ Memory Stability Audit {#memGrowth}

Memory RSS Δ: — (not measured in this run) | Target: < 60MB | Trend: ⚪ (—)

Peak memory growth during stress workload.

Enterprise scale audit

🏷️ Multi-Tenancy Performance {#tenancyAvg}

Tenancy p95: — (not measured in this run) | Trend: ⚪ (—)

Measures latency across tenant isolation boundaries.

🏷️ Relational Resolver Latency {#relationalAvg}

Relational p95: — (not measured in this run) | Trend: ⚪ (—)

Tests performance of complex JOINs and nested relationship population.

🏷️ Telemetry & Update Performance {#telemetryAvg}

Telemetry p95: — (not measured in this run) | Trend: ⚪ (—)

Measures overhead of telemetry collection and cryptographic signing.

🔬 Full benchmark ledger (35 modules)

Expand dimension groups, then any row, for ASCII truth tables. Executive summary above shows pass/fail and issues only.

Core · 10 tests

🏷️ API LAYER LATENCY · ⚪ 1.816ms · ↗️ — · source

> [!NOTE] > **Specific to this test**: Both avg and p95 degraded — likely adapter or infrastructure bottleneck. Check DB connection pool, indexes, or recent commits. Throughput dropped 80% — check connection pool saturation or lock contention. **Severe degradation** (+511%) — review recent commits immediately. > **Check**: `src/routes/api/[...path]/+server.ts` · `src/hooks.server.ts`

⏳ API LAYER LATENCY: Pending execution. 🎯 Measures the base network and HTTP overhead for the simplest possible API calls.

🏷️ PHASED COLD START · ⚪ ⏳ pending · ➡️ — · source

> ⏳ **PHASED COLD START**: Pending execution. > 🎯 Measures the time to READY state (serving traffic) vs WARMED state (background tasks).

🏷️ SRE TRUTH AUDIT · ⚪ ⏳ pending · ↘️ — · source

> [!NOTE] > **Specific to this test**: Performance improved — recent optimizations or cache warming likely effective.

╔═══════════════════════════════════════════════════════════════════════════════════════════════════════╗
║                                      SVELTYCMS — SRE TRUTH AUDIT                                      ║
║                             File: tests/benchmarks/truth-latency.test.ts                              ║
║                                       Ran: 2026-10-06 12:40:05                                        ║
║            Validates performance claims by comparing SDK, Middleware, and Real HTTP Stack             ║
╠═══════════════════════════════════════════════════════════════════════════════════════════════════════╣
║ Logic Baseline               │ Cold:     0.01 ms │ Warm:     0.000 ms │ p95:     0.000 ms │ 582,751 RPS ║
║ Local SDK (Full)             │ Cold:    14.49 ms │ Warm:     0.006 ms │ p95:     0.012 ms │ 135,974 RPS ║
║ HTTP End-to-End              │ Cold:     4.34 ms │ Warm:     0.252 ms │ p95:     0.322 ms │   3,940 RPS ║
║ HTTP Cold (Cache-Busted)     │ Cold:     2.26 ms │ Warm:     1.102 ms │ p95:     1.428 ms │     906 RPS ║
╚═══════════════════════════════════════════════════════════════════════════════════════════════════════╝

🏷️ Incremental Content Reload · ⚪ 0.550ms · ↗️ — · source

> [!NOTE] > **Specific to this test**: Both avg and p95 degraded — likely adapter or infrastructure bottleneck. Check DB connection pool, indexes, or recent commits. Throughput dropped 72% — check connection pool saturation or lock contention. **Severe degradation** (+150%) — review recent commits immediately. > **Check**: `src/content/engine.server.ts` · `src/routes/api/[...path]/handlers/content.ts`

╔═══════════════════════════════════════════════════════════════════════════════════════════════════════╗
║                             SVELTYCMS — INCREMENTAL CONTENT RELOAD AUDIT                              ║
║                       File: tests/benchmarks/content-incremental-reload.test.ts                       ║
║                                       Ran: 2026-10-06 12:44:32                                        ║
║      Measures surgical single-file fullReload vs full reconciliation path and batch processing.       ║
╠═══════════════════════════════════════════════════════════════════════════════════════════════════════╣
║ Incremental fullReload (1 file) │ Cold:     4.74 ms │ Warm:     0.066 ms │ p95:     0.124 ms │  13,661 RPS ║
║ Full Reconciliation Reload   │ Cold:     2.41 ms │ Warm:     0.171 ms │ p95:     0.250 ms │   5,627 RPS ║
║ Sequential 10-File Reload    │ Cold:     4.12 ms │ Warm:     0.550 ms │ p95:     0.791 ms │   1,700 RPS ║
║ Batched 10-File Reload       │ Cold:     0.88 ms │ Warm:     0.248 ms │ p95:     0.444 ms │   3,485 RPS ║
╚═══════════════════════════════════════════════════════════════════════════════════════════════════════╝

🏷️ State Machine Transitions · ⚪ 28.154ms · ↘️ — · source

> [!NOTE] > **Specific to this test**: Performance improved — recent optimizations or cache warming likely effective.

╔═══════════════════════════════════════════════════════════════════════════════════════════════════════╗
║                                  SVELTYCMS — STATE MACHINE INTEGRITY                                  ║
║                        File: tests/benchmarks/state-machine-transition.test.ts                        ║
║                                       Ran: 2026-10-06 12:44:44                                        ║
║Measures state machine self-healing transition latencies, convergence settling time, and health probe consistency under stress.║
╠═══════════════════════════════════════════════════════════════════════════════════════════════════════╣
║ State Transition (Transient) │ Cold:    38.72 ms │ Warm:    28.154 ms │ p95:    35.104 ms │      36 RPS ║
║ Self-Healing Full Convergence │ Cold:    31.24 ms │ Warm:    31.280 ms │ p95:    35.127 ms │      33 RPS ║
╚═══════════════════════════════════════════════════════════════════════════════════════════════════════╝

🏷️ Database Adapter Raw CRUD · ⚪ 1.302ms · ↗️ — · source

> [!NOTE] > **Specific to this test**: Avg degraded but p95 stable — possible cold-start effect, GC pause, or warmup variance. Throughput dropped 99% — check connection pool saturation or lock contention. **Severe degradation** (+91%) — review recent commits immediately.

⏳ Database Adapter Raw CRUD: Pending execution. 🎯 Direct low-level benchmarks of Create, Read, Update, Delete on the current database adapter.

🏷️ ACID Transaction Overhead · ⚪ 0.648ms · ➡️ — · source

``` ╔═══════════════════════════════════════════════════════════════════════════════════════════════════════╗ ║ SVELTYCMS — ACID INTEGRITY AUDIT ║ ║ File: tests/benchmarks/transaction-acid.test.ts ║ ║ Ran: 2026-10-06 12:44:16 ║ ║ Measures transaction commit latencies and rollback overhead across database adapters ║ ╠═══════════════════════════════════════════════════════════════════════════════════════════════════════╣ ║ TX Commit │ Cold: 0.05 ms │ Warm: 0.000 ms │ p95: 0.002 ms │ 848,536 RPS ║ ║ TX Rollback Integrity │ Cold: 1.73 ms │ Warm: 0.648 ms │ p95: 0.796 ms │ 1,538 RPS ║ ╚═══════════════════════════════════════════════════════════════════════════════════════════════════════╝ ```

🏷️ COMPETITIVE 9-WORKLOAD REPLICA · ⚪ 1.271ms · ↗️ — · source

> [!NOTE] > **Specific to this test**: Avg degraded but p95 stable — possible cold-start effect, GC pause, or warmup variance. Throughput dropped 87% — check connection pool saturation or lock contention. **Severe degradation** (+82%) — review recent commits immediately.

╔═══════════════════════════════════════════════════════════════════════════════════════════════════════╗
║                    COMPETITIVE HARNESS REPLICA (MONGODB — 500 Docs, COLD vs WARM)                     ║
║                      File: tests/benchmarks/competitive-workload-replica.test.ts                      ║
║                                       Ran: 2026-10-06 12:46:50                                        ║
║              Seq + concurrent (8 workers), harness iteration counts, median of N rounds.              ║
╠═══════════════════════════════════════════════════════════════════════════════════════════════════════╣
║ findById (Cold Sequential)   │ Cold:     3.83 ms │ Warm:     0.404 ms │ p95:     0.562 ms │   2,425 RPS ║
║ findById (Cold Concurrent 8c) │ Cold:     1.49 ms │ Warm:     1.732 ms │ p95:     2.081 ms │   4,470 RPS ║
║ findByIdRandom (Cold Sequential) │ Cold:     2.27 ms │ Warm:     1.176 ms │ p95:     1.556 ms │     848 RPS ║
║ findByIdRandom (Cold Concurrent 8c) │ Cold:     2.27 ms │ Warm:     3.616 ms │ p95:     4.069 ms │   2,146 RPS ║
║ listFilterSort (Cold Sequential) │ Cold:     4.46 ms │ Warm:     0.411 ms │ p95:     0.477 ms │   2,418 RPS ║
║ listFilterSort (Cold Concurrent 8c) │ Cold:     0.46 ms │ Warm:     1.604 ms │ p95:     2.815 ms │   4,847 RPS ║
║ listLarge (Cold Sequential)  │ Cold:     6.25 ms │ Warm:     0.441 ms │ p95:     0.513 ms │   2,257 RPS ║
║ listLarge (Cold Concurrent 8c) │ Cold:     0.40 ms │ Warm:     0.966 ms │ p95:     1.255 ms │   7,960 RPS ║
║ listPlain (Cold Sequential)  │ Cold:     3.43 ms │ Warm:     0.273 ms │ p95:     0.317 ms │   3,648 RPS ║
║ listPlain (Cold Concurrent 8c) │ Cold:     0.31 ms │ Warm:     0.857 ms │ p95:     1.228 ms │   8,976 RPS ║
║ findMissing (Cold Sequential) │ Cold:     2.32 ms │ Warm:     0.216 ms │ p95:     0.253 ms │   4,613 RPS ║
║ findMissing (Cold Concurrent 8c) │ Cold:     0.19 ms │ Warm:     0.620 ms │ p95:     0.804 ms │  12,445 RPS ║
║ create (Cold Sequential)     │ Cold:     4.25 ms │ Warm:     1.629 ms │ p95:     2.844 ms │     613 RPS ║
║ create (Cold Concurrent 8c)  │ Cold:     4.16 ms │ Warm:     6.295 ms │ p95:     7.202 ms │   1,233 RPS ║
║ update (Cold Sequential)     │ Cold:     3.50 ms │ Warm:     1.744 ms │ p95:     2.742 ms │     573 RPS ║
║ update (Cold Concurrent 8c)  │ Cold:     4.41 ms │ Warm:     6.071 ms │ p95:     6.707 ms │   1,283 RPS ║
║ graphql (Cold Sequential)    │ Cold:     4.51 ms │ Warm:     1.219 ms │ p95:     4.016 ms │     819 RPS ║
║ graphql (Cold Concurrent 8c) │ Cold:     2.13 ms │ Warm:     1.977 ms │ p95:     3.806 ms │   3,933 RPS ║
║ mixed (Cold Sequential)      │ Cold:     1.56 ms │ Warm:     0.905 ms │ p95:     1.519 ms │   1,103 RPS ║
║ mixed (Cold Concurrent 8c)   │ Cold:     0.36 ms │ Warm:     3.331 ms │ p95:     5.831 ms │   2,356 RPS ║
║ findById (Warm Sequential)   │ Cold:     0.66 ms │ Warm:     0.208 ms │ p95:     0.277 ms │   4,778 RPS ║
║ findById (Warm Concurrent 8c) │ Cold:     0.13 ms │ Warm:     0.576 ms │ p95:     0.703 ms │  13,757 RPS ║
║ findByIdRandom (Warm Sequential) │ Cold:     0.66 ms │ Warm:     0.237 ms │ p95:     0.319 ms │   4,206 RPS ║
║ findByIdRandom (Warm Concurrent 8c) │ Cold:     0.28 ms │ Warm:     0.617 ms │ p95:     0.812 ms │  12,875 RPS ║
║ listFilterSort (Warm Sequential) │ Cold:     0.74 ms │ Warm:     0.217 ms │ p95:     0.302 ms │   4,572 RPS ║
║ listFilterSort (Warm Concurrent 8c) │ Cold:     0.26 ms │ Warm:     0.709 ms │ p95:     0.935 ms │  11,079 RPS ║
║ listLarge (Warm Sequential)  │ Cold:     0.76 ms │ Warm:     0.309 ms │ p95:     0.433 ms │   3,222 RPS ║
║ listLarge (Warm Concurrent 8c) │ Cold:     0.37 ms │ Warm:     0.840 ms │ p95:     1.345 ms │   9,367 RPS ║
║ listPlain (Warm Sequential)  │ Cold:     0.77 ms │ Warm:     0.169 ms │ p95:     0.238 ms │   5,895 RPS ║
║ listPlain (Warm Concurrent 8c) │ Cold:     0.24 ms │ Warm:     0.502 ms │ p95:     0.659 ms │  15,624 RPS ║
║ findMissing (Warm Sequential) │ Cold:     2.28 ms │ Warm:     0.128 ms │ p95:     0.188 ms │   7,746 RPS ║
║ findMissing (Warm Concurrent 8c) │ Cold:     0.15 ms │ Warm:     0.403 ms │ p95:     0.563 ms │  19,245 RPS ║
║ create (Warm Sequential)     │ Cold:     2.82 ms │ Warm:     1.077 ms │ p95:     1.223 ms │     927 RPS ║
║ create (Warm Concurrent 8c)  │ Cold:     2.47 ms │ Warm:     4.610 ms │ p95:     7.314 ms │   1,720 RPS ║
║ update (Warm Sequential)     │ Cold:     3.39 ms │ Warm:     1.271 ms │ p95:     1.472 ms │     786 RPS ║
║ update (Warm Concurrent 8c)  │ Cold:     2.94 ms │ Warm:     5.011 ms │ p95:     7.819 ms │   1,579 RPS ║
║ graphql (Warm Sequential)    │ Cold:     1.66 ms │ Warm:     0.849 ms │ p95:     0.983 ms │   1,177 RPS ║
║ graphql (Warm Concurrent 8c) │ Cold:     0.99 ms │ Warm:     1.487 ms │ p95:     1.878 ms │   5,285 RPS ║
║ mixed (Warm Sequential)      │ Cold:     2.66 ms │ Warm:     0.700 ms │ p95:     1.562 ms │   1,427 RPS ║
║ mixed (Warm Concurrent 8c)   │ Cold:     1.06 ms │ Warm:     1.796 ms │ p95:     3.150 ms │   4,330 RPS ║
╚═══════════════════════════════════════════════════════════════════════════════════════════════════════╝

🏷️ MIDDLEWARE FLAMEGRAPH PROFILER · ⚪ 1.311ms · ↗️ — · source

> [!NOTE] > **Specific to this test**: Both avg and p95 degraded — likely adapter or infrastructure bottleneck. Check DB connection pool, indexes, or recent commits. Throughput dropped 53% — check connection pool saturation or lock contention. **Severe degradation** (+68%) — review recent commits immediately.

╔═══════════════════════════════════════════════════════════════════════════════════════════════════════╗
║                               MIDDLEWARE FLAMEGRAPH PROFILER (MONGODB)                                ║
║                         File: tests/benchmarks/middleware-flamegraph.test.ts                          ║
║                                       Ran: 2026-10-06 12:47:33                                        ║
║Measures isolated microsecond cost and incremental deltas of each middleware stage from edge to database.║
╠═══════════════════════════════════════════════════════════════════════════════════════════════════════╣
║ Stage 0: Raw Socket Baseline (Static Asset) │ Cold:     2.60 ms │ Warm:     0.779 ms │ p95:     1.193 ms │   4,933 RPS ║
║ Stage 1: System State + Turbo Pipeline │ Cold:     1.07 ms │ Warm:     0.859 ms │ p95:     1.442 ms │   4,387 RPS ║
║ Stage 2: WAF Security Inspection │ Cold:     1.02 ms │ Warm:     0.572 ms │ p95:     0.826 ms │   6,568 RPS ║
║ Stage 3: Token Auth Gating   │ Cold:     6.43 ms │ Warm:     1.363 ms │ p95:     2.030 ms │   2,835 RPS ║
║ Stage 4: Collection Schema Resolution │ Cold:     2.23 ms │ Warm:     0.341 ms │ p95:     0.429 ms │  10,993 RPS ║
║ Stage 5: Full REST Single Document │ Cold:     4.68 ms │ Warm:     0.291 ms │ p95:     0.368 ms │  12,861 RPS ║
║ Stage 6: GraphQL Single Query (JIT) │ Cold:     4.82 ms │ Warm:     1.311 ms │ p95:     1.539 ms │   3,037 RPS ║
╚═══════════════════════════════════════════════════════════════════════════════════════════════════════╝

🏷️ EVENT LOOP LAG & SATURATION · ⚪ ⏳ pending · ➡️ — · source

> ⏳ **EVENT LOOP LAG & SATURATION**: Pending execution. > 🎯 Measures event loop delay and microtask drain during continuous write bursts.

API · 9 tests

🏷️ Temporal Integrity Audit · ⚪ 2.951ms · ➡️ — · source

``` ╔═══════════════════════════════════════════════════════════════════════════════════════════════════════╗ ║ SVELTYCMS — TEMPORAL INTEGRITY AUDIT ║ ║ File: tests/benchmarks/temporal-integrity.test.ts ║ ║ Ran: 2026-10-06 12:42:05 ║ ║Validates strict backend UTC normalization (ISO 8601 with trailing 'Z') across global timezone offsets, fractional timezones, and midnight transitions.║ ╠═══════════════════════════════════════════════════════════════════════════════════════════════════════╣ ║ Temporal Ingestion & Normalization │ Cold: 2.38 ms │ Warm: 2.951 ms │ p95: 5.546 ms │ 1,225 RPS ║ ╚═══════════════════════════════════════════════════════════════════════════════════════════════════════╝ ```

🏷️ Relational & Nested Queries · ⚪ ⏳ pending · ➡️ — · source

> ⏳ **Relational & Nested Queries**: Pending execution. > 🎯 Stress-tests JOINs, population strategies, and deeply nested relationships (depth 2–3).

🏷️ Auth & RBAC Performance · ⚪ 0.797ms · ➡️ — · source

> ⏳ **Auth & RBAC Performance**: Pending execution. > 🎯 Measures JWT verification, session retrieval, and permission matrix resolution overhead.

🏷️ REST API Performance · ⚪ 1.989ms · ↗️ — · source

> [!NOTE] > **Specific to this test**: Both avg and p95 degraded — likely adapter or infrastructure bottleneck. Check DB connection pool, indexes, or recent commits. Throughput dropped 48% — check connection pool saturation or lock contention. **Severe degradation** (+92%) — review recent commits immediately.

╔═══════════════════════════════════════════════════════════════════════════════════════════════════════╗
║                                 SVELTYCMS — ENTERPRISE REST API AUDIT                                 ║
║                          File: tests/benchmarks/rest-api-performance.test.ts                          ║
║                                       Ran: 2026-10-06 12:40:17                                        ║
║Measures latency, throughput, and correctness of core REST endpoints: health check, schema, single read, list, and search.║
╠═══════════════════════════════════════════════════════════════════════════════════════════════════════╣
║ System Health Check          │ Cold:     1.14 ms │ Warm:     1.989 ms │ p95:     2.921 ms │   5,807 RPS ║
║ Collection Schema Metadata   │ Cold:     3.09 ms │ Warm:     0.749 ms │ p95:     0.918 ms │  15,400 RPS ║
║ Single Document Read         │ Cold:     0.64 ms │ Warm:     0.742 ms │ p95:     0.875 ms │  15,449 RPS ║
║ Collection Find (List Limit 20) │ Cold:     5.33 ms │ Warm:     0.969 ms │ p95:     1.195 ms │  12,027 RPS ║
║ Collection Search Query      │ Cold:     3.09 ms │ Warm:     1.038 ms │ p95:     1.639 ms │  10,930 RPS ║
╚═══════════════════════════════════════════════════════════════════════════════════════════════════════╝

🏷️ GraphQL API Performance · ⚪ 0.740ms · ↘️ — · source

> [!NOTE] > **Specific to this test**: Performance improved — recent optimizations or cache warming likely effective. Throughput dropped 60% — check connection pool saturation or lock contention.

╔═══════════════════════════════════════════════════════════════════════════════════════════════════════╗
║                                  SVELTYCMS — GRAPHQL CACHE HIT AUDIT                                  ║
║                           File: tests/benchmarks/graphql-cache-hit.test.ts                            ║
║                                       Ran: 2026-10-06 12:47:03                                        ║
║        Validates sub-millisecond L1 response cache hits, cache key isolation, and hit headers.        ║
╠═══════════════════════════════════════════════════════════════════════════════════════════════════════╣
║ Q1: Health (Cold Miss)         │        4.149 ms │ p95:        4.149 ms │ RPS:        241 ║
║ Q1: Health (L1 Hit)            │        1.101 ms │ p95:        1.966 ms │ RPS:        908 ║
║ Q2: Collections (Cold Miss)    │        2.190 ms │ p95:        2.190 ms │ RPS:        457 ║
║ Q2: Collections (L1 Hit)       │        1.082 ms │ p95:        1.257 ms │ RPS:        924 ║
╚═══════════════════════════════════════════════════════════════════════════════════════════════════════╝

🏷️ Enterprise SEO Suite Audit · ⚪ 1.614ms · ➡️ — · source

``` ╔═══════════════════════════════════════════════════════════════════════════════════════════════════════╗ ║ SVELTYCMS — ENTERPRISE SEO AUDIT ║ ║ File: tests/benchmarks/seo-performance.test.ts ║ ║ Ran: 2026-10-06 12:41:10 ║ ║Measures redirect lookup latency, dynamic sitemap.xml generation, robots.txt serving, and 404 logging performance.║ ╠═══════════════════════════════════════════════════════════════════════════════════════════════════════╣ ║ Redirect Lookup (301) │ Cold: 1.62 ms │ Warm: 1.555 ms │ p95: 2.206 ms │ 5,094 RPS ║ ║ Dynamic Sitemap XML │ Cold: 5.13 ms │ Warm: 0.845 ms │ p95: 1.139 ms │ 9,368 RPS ║ ║ Robots.txt Generation │ Cold: 1.47 ms │ Warm: 1.614 ms │ p95: 2.653 ms │ 4,923 RPS ║ ║ Missing Path (404 Log) │ Cold: 55.60 ms │ Warm: 15.758 ms │ p95: 22.088 ms │ 505 RPS ║ ╚═══════════════════════════════════════════════════════════════════════════════════════════════════════╝ ```

🏷️ REAL-TIME BROADCAST AUDIT · ⚪ 0.138ms · ➡️ — · source

> ⏳ **REAL-TIME BROADCAST AUDIT**: Pending execution. > 🎯 Benchmarks network-layer broadcast latency (SSE vs WebSocket).

🏷️ WebSocket & Realtime Latency · ⚪ ⏳ pending · ➡️ — · source

> ⏳ **WebSocket & Realtime Latency**: Pending execution. > 🎯 Benchmarks WebSocket connection/broadcast latency.

🏷️ GraphQL Response Cache Hit · ⚪ 1.082ms · ↘️ — · source

> [!NOTE] > **Specific to this test**: Performance improved — recent optimizations or cache warming likely effective.

⏳ GraphQL Response Cache Hit: Pending execution. 🎯 L1 response cache: cold-query vs cache-hit latency verification.

Scale · 15 tests

🏷️ Negative Cache Performance · ⚪ 0.001ms · ↘️ — · source

> [!NOTE] > **Specific to this test**: Performance improved — recent optimizations or cache warming likely effective.

╔═══════════════════════════════════════════════════════════════════════════════════════════════════════╗
║                             SVELTYCMS — NEGATIVE CACHE PERFORMANCE AUDIT                              ║
║                             File: tests/benchmarks/negative-cache.test.ts                             ║
║                                       Ran: 2026-10-06 12:40:51                                        ║
║Measures Bloom-filter style missing-key cache speedup for repeated misses against direct database miss baselines.║
╠═══════════════════════════════════════════════════════════════════════════════════════════════════════╣
║ Direct DB Miss Baseline      │ Cold:     2.69 ms │ Warm:     0.665 ms │ p95:     0.849 ms │   1,457 RPS ║
║ Cold Miss (Bypass Cache)     │ Cold:     8.11 ms │ Warm:     0.536 ms │ p95:     0.624 ms │   1,851 RPS ║
║ Hot Miss (Negative Cache)    │ Cold:     0.24 ms │ Warm:     0.001 ms │ p95:     0.003 ms │ 728,856 RPS ║
╚═══════════════════════════════════════════════════════════════════════════════════════════════════════╝

🏷️ Memory Stability & GC Behavior · ⚪ ⏳ pending · ➡️ — · source

> ⏳ **Memory Stability & GC Behavior**: Pending execution. > 🎯 Long-running soak test to identify memory leaks and GC pressure.

🏷️ Multi-Tenant Performance & Isolation · ⚪ 0.545ms · ➡️ — · source

``` ╔═══════════════════════════════════════════════════════════════════════════════════════════════════════╗ ║ SVELTYCMS — MULTI-TENANCY PERFORMANCE AUDIT ║ ║ File: tests/benchmarks/multi-tenant-performance.test.ts ║ ║ Ran: 2026-10-06 12:40:56 ║ ║Measures the overhead of tenant isolation, context switching, and data partitioning across many tenants.║ ╠═══════════════════════════════════════════════════════════════════════════════════════════════════════╣ ║ Single Tenant Baseline │ Cold: 4.21 ms │ Warm: 0.658 ms │ p95: 0.937 ms │ 11,310 RPS ║ ║ Multi-Tenant Context Switching │ Cold: 0.83 ms │ Warm: 0.545 ms │ p95: 0.707 ms │ 14,078 RPS ║ ╚═══════════════════════════════════════════════════════════════════════════════════════════════════════╝ ```

🏷️ Realistic Mixed Workload · ⚪ 0.752ms · ➡️ — · source

``` ╔═══════════════════════════════════════════════════════════════════════════════════════════════════════╗ ║ SVELTYCMS — MIXED WORKLOAD AUDIT ║ ║ File: tests/benchmarks/mixed-workload.test.ts ║ ║ Ran: 2026-10-06 12:41:13 ║ ║Simulates real-world traffic with a weighted mix of reads, searches, GraphQL queries, and metadata requests with per-operation telemetry.║ ╠═══════════════════════════════════════════════════════════════════════════════════════════════════════╣ ║ Mixed Workload │ Cold: 6.47 ms │ Warm: 0.752 ms │ p95: 2.312 ms │ 8,234 RPS ║ ║ Mix: REST Read │ 0.835 ms │ p95: 1.224 ms │ RPS: 2,015 ║ ║ Mix: REST Search │ 0.869 ms │ p95: 1.329 ms │ RPS: 669 ║ ║ Mix: GraphQL │ 2.333 ms │ p95: 3.392 ms │ RPS: 478 ║ ║ Mix: Metadata │ 0.866 ms │ p95: 1.317 ms │ RPS: 170 ║ ╚═══════════════════════════════════════════════════════════════════════════════════════════════════════╝ ```

🏷️ GraphQL Load Stress · ⚪ 9.302ms · ↗️ — · source

> [!NOTE] > **Specific to this test**: Both avg and p95 degraded — likely adapter or infrastructure bottleneck. Check DB connection pool, indexes, or recent commits. **Severe degradation** (+113%) — review recent commits immediately.

⏳ GraphQL Load Stress: Pending execution. 🎯 High-concurrency GraphQL query stress test for resolver efficiency.

🏷️ Bulk Migration & Scale · ⚪ 0.512ms · ↘️ — · source

> [!NOTE] > **Specific to this test**: Performance improved — recent optimizations or cache warming likely effective.

╔═══════════════════════════════════════════════════════════════════════════════════════════════════════╗
║                                  SVELTYCMS — MIGRATION & SCALE AUDIT                                  ║
║                            File: tests/benchmarks/migration-scale.test.ts                             ║
║                                       Ran: 2026-10-06 12:45:26                                        ║
║Measures bulk ingestion throughput for 10,000 entries, random point-lookups, and indexed range scans across large datasets.║
╠═══════════════════════════════════════════════════════════════════════════════════════════════════════╣
║ Bulk Migration (10k docs)    │ Cold:    40.53 ms │ Warm:    19.405 ms │ p95:    26.135 ms │  23,995 RPS ║
║ Random Point Lookup          │ Cold:     3.25 ms │ Warm:     1.865 ms │ p95:     2.146 ms │   3,159 RPS ║
║ Range Scan & Pagination      │ Cold:    35.73 ms │ Warm:     0.512 ms │ p95:     0.916 ms │  10,650 RPS ║
╚═══════════════════════════════════════════════════════════════════════════════════════════════════════╝

🏷️ Million-Row Index Pressure · ⚪ 0.387ms · ↘️ — · source

> [!NOTE] > **Specific to this test**: Performance improved — recent optimizations or cache warming likely effective.

╔═══════════════════════════════════════════════════════════════════════════════════════════════════════╗
║                                  SVELTYCMS  —  INDEX PRESSURE AUDIT                                   ║
║                             File: tests/benchmarks/index-pressure.test.ts                             ║
║                                       Ran: 2026-10-06 12:42:17                                        ║
║           Measures read performance with sorting and filtering on a large entry collection.           ║
╠═══════════════════════════════════════════════════════════════════════════════════════════════════════╣
║ Sorted List (25k rows)       │ Cold:     2.63 ms │ Warm:     0.387 ms │ p95:     0.513 ms │  10,243 RPS ║
║ Filtered Query (25k rows)    │ Cold:     2.94 ms │ Warm:     0.339 ms │ p95:     0.385 ms │  11,730 RPS ║
╚═══════════════════════════════════════════════════════════════════════════════════════════════════════╝

🏷️ Content Scale Stress · ⚪ 0.146ms · ↘️ — · source

> [!NOTE] > **Specific to this test**: Performance improved — recent optimizations or cache warming likely effective.

⏳ Content Scale Stress: Pending execution. 🎯 Measures content scan performance on 1,000+ collections under .compiledCollections/test/stress (isolated).

🏷️ Media Upload Stress & Throughput · ⚪ 7.117ms · ↗️ — · source

> [!NOTE] > **Specific to this test**: Avg degraded but p95 stable — possible cold-start effect, GC pause, or warmup variance. > **Check**: `src/services/MediaService.ts` · `src/databases/media/`

╔═══════════════════════════════════════════════════════════════════════════════════════════════════════╗
║                                 SVELTYCMS — MEDIA UPLOAD STRESS AUDIT                                 ║
║                          File: tests/benchmarks/media-upload-stress.test.ts                           ║
║                                       Ran: 2026-10-06 12:45:13                                        ║
║Measures throughput for large file uploads, concurrent transfers, and streaming efficiency with valid media fixtures.║
╠═══════════════════════════════════════════════════════════════════════════════════════════════════════╣
║ Single Upload (0.01MB)       │ Cold:    11.51 ms │ Warm:     6.242 ms │ p95:     6.761 ms │     160 RPS ║
║ Small Upload (0MB @ 4c)      │ Cold:     8.30 ms │ Warm:     7.117 ms │ p95:     9.450 ms │     539 RPS ║
╚═══════════════════════════════════════════════════════════════════════════════════════════════════════╝

🏷️ Full Client Journey Simulation · ⚪ 3.470ms · ➡️ — · source

> ⏳ **Full Client Journey Simulation**: Pending execution. > 🎯 E2E journey: Login -> List -> View -> Edit -> Save -> Realtime. Measures cumulative latency.

🏷️ Concurrency & Race Condition · ⚪ ⏳ pending · ➡️ — · source

``` ╔═══════════════════════════════════════════════════════════════════════════════════════════════════════╗ ║ SVELTYCMS — CONCURRENCY AUDIT ║ ║ File: tests/benchmarks/concurrency-race.test.ts ║ ║ Ran: 2026-10-06 12:45:32 ║ ║ Simulates high-concurrency writes to a single document to prove atomic consistency. ║ ╠═══════════════════════════════════════════════════════════════════════════════════════════════════════╣ ║ Concurrent PATCH Bomb │ 49.352 ms │ p95: 61.297 ms │ RPS: 1,584 ║ ╚═══════════════════════════════════════════════════════════════════════════════════════════════════════╝ ```

🏷️ Multi-Doc Concurrency Throughput · ⚪ ⏳ pending · ➡️ — · source

``` ╔═══════════════════════════════════════════════════════════════════════════════════════════════════════╗ ║ SVELTYCMS — DIRECT ADAPTER THROUGHPUT (MONGODB) ║ ║ File: tests/benchmarks/local-api-throughput.test.ts ║ ║ Ran: 2026-10-06 12:42:28 ║ ║Measures direct adapter write throughput, read throughput, and percentile latencies with zero HTTP overhead.║ ╠═══════════════════════════════════════════════════════════════════════════════════════════════════════╣ ║ Writes (1000 atomic increments) │ 2.395 ms │ p95: 4.324 ms │ RPS: 2,373 ║ ║ Reads (1000 point lookups) │ 4.280 ms │ p95: 6.851 ms │ RPS: 8,394 ║ ╚═══════════════════════════════════════════════════════════════════════════════════════════════════════╝ ```

🏷️ Max Throughput — No Throttle · ⚪ 69.379ms · ➡️ — · source

> ⏳ **Max Throughput — No Throttle**: Pending execution. > 🎯 1000 concurrent writes across 100 docs — no semaphore.

🏷️ Production Day Simulation · ⚪ 1.528ms · ➡️ — · source

> ⏳ **Production Day Simulation**: Pending execution. > 🎯 Full production day with mixed workload, 100% reliability.

Resilience · 5 tests

🏷️ Circuit Breaker Failover · ⚪ ⏳ pending · ➡️ — · source

> ⏳ **Circuit Breaker Failover**: Pending execution. > 🎯 Measures system graceful degradation when external services fail.

🏷️ Throttling & Backoff Stress · ⚪ ⏳ pending · ➡️ — · source

> ⏳ **Throttling & Backoff Stress**: Pending execution. > 🎯 Measures rate-limiting consistency under 10x design load.

🏷️ Data Residency & Sovereignty · ⚪ ⏳ pending · ➡️ — · source

> ⏳ **Data Residency & Sovereignty**: Pending execution. > 🎯 PII blocking and data sovereignty enforcement with cross-region failover.

🏷️ Database Failover & Reconnection · ⚪ ⏳ pending · ➡️ — · source

> ⏳ **Database Failover & Reconnection**: Pending execution. > 🎯 Simulates DB disconnect mid-request — measures circuit breaker activation and reconnection timing.

🔬 Host environment

Host	Platform	Arch	Cores	RAM	Runtime
RKroells	win32	x64	24	63GB	Bun 1.4.2