Skip to content

Documentation

SQLite + Redis Performance Audit

Database performance benchmarks with trend analysis and competitive context.

7/4/2026
13 min read Edit on GitHub
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.

Note

Partial update — dimension rollups and issues reflect only tests invoked in this run.

✅ PASS (partial invocation) · 1/58 tests · 57 skipped · sqlite-redis · standalone run

Dimension health

Dimension Tests Status Worst Δ Issues
Core 8 🟢 0
API 0 0
Scale 0 0
Resilience 0 0

Issues (action required)

All clear — no regressions or budget violations detected.

Executive latency matrix

Scenario Latency Trend Budget Result
Database Performance 0.113ms ⚪ established at 0.113ms (1 run) < 5ms 🟢
Database Performance 0.062ms ⚪ established at 0.062ms (1 run) < 5ms 🟢
Database Performance 0.076ms ⚪ established at 0.076ms (1 run) < 5ms 🟢
Database Performance 0.086ms ⚪ established at 0.086ms (1 run) < 5ms 🟢
Database Performance 0.054ms ⚪ established at 0.054ms (1 run) < 5ms 🟢
Database Performance 0.146ms ⚪ established at 0.146ms (1 run) < 5ms 🟢
Database Performance 0.036ms ⚪ established at 0.036ms (1 run) < 5ms 🟢
Database Performance 2.866ms ⚪ established at 2.87ms (1 run) < 5ms 🟢

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 "sqlite-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]

Current Run Summary (2026-07-21)

Scope: Only tests that ran in THIS invocation.

⚠️ Executive PASS/FAIL reflects the last full matrix run.

Run ID: 6f78d92f-ccd6-4f4a-923c-4a050b9e0a07 · Tests invoked: 1 · Metrics: 8 · DB: sqlite-redis

Test Metric Avg (ms) p95 (ms) RPS Trend Detail
Database Performance INSERT 0.113 0.172 3064 🟢 ⚪ established at 0.113ms (1 run)
Database Performance FIND ONE 0.062 0.076 14371 🟢 ⚪ established at 0.062ms (1 run)
Database Performance FIND MANY (limit 50) 0.076 0.091 12057 🟢 ⚪ established at 0.076ms (1 run)
Database Performance UPDATE 0.086 0.111 9202 🟢 ⚪ established at 0.086ms (1 run)
Database Performance NATIVE UPSERT 0.054 0.063 14702 🟢 ⚪ established at 0.054ms (1 run)
Database Performance COUNT 0.146 0.181 6251 🟢 ⚪ established at 0.146ms (1 run)
Database Performance DELETE 0.036 0.044 19645 🟢 ⚪ established at 0.036ms (1 run)
Database Performance BULK INSERT (100) 2.866 5.448 149 🟢 ⚪ established at 2.87ms (1 run)

Historical Trends (2026-07-21)

⏳ No history recorded yet.

🔬 Full benchmark ledger (41 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 · ⏳ pending · ➡️ baseline · source

⏳ Pending — Measures the base network and HTTP overhead for the simplest possible API calls.

🏷️ PHASED COLD START · ⏳ pending · ➡️ baseline · source

⏳ Pending — Measures the time to READY state (serving traffic) vs WARMED state (background tasks).

🏷️ SRE TRUTH AUDIT · ⏳ pending · ➡️ baseline · source

⏳ Pending — The definitive truth audit: SDK vs Dispatcher vs Real HTTP (Production Standalone).

🏷️ Incremental Content Reload · ⏳ pending · ➡️ baseline · source

⏳ Pending — Measures surgical single-file fullReload vs full reconciliation + SCHEMA cache wipe.

🏷️ Middleware & Hooks Performance · ⏳ pending · ➡️ baseline · source

⏳ Pending — High-resolution micro-benchmarks (µs) for individual middleware layers.

🏷️ State Machine Transitions · ⏳ pending · ➡️ baseline · source

⏳ Pending — Validates rapid IDLE -> READY self-healing cycles.

🏷️ Database Adapter Raw CRUD · ⏳ pending · ➡️ baseline · source

⏳ Pending — Direct low-level benchmarks of Create, Read, Update, Delete on the current database adapter.

🏷️ ACID Transaction Overhead · ⏳ pending · ➡️ baseline · source

⏳ Pending — Measures commit/rollback latency and transaction isolation performance.

🏷️ System Cache Efficiency · ⏳ pending · ➡️ baseline · source

⏳ Pending — Audits the performance gain of the 2-layer Hybrid Cache across various system modules.

🏷️ Cache Hit/Miss Ratio & Efficiency · ⏳ pending · ➡️ baseline · source

⏳ Pending — Measures Redis cache hit/miss ratio, cold vs warm read speedup, and invalidation performance.

API · 8 tests
🏷️ Temporal Integrity Audit · ⏳ pending · ➡️ baseline · source

⏳ Pending — Verifies timezone normalization and deterministic UTC persistence.

🏷️ Relational & Nested Queries · ⏳ pending · ➡️ baseline · source

⏳ Pending — Stress-tests JOINs, population strategies, and deeply nested relationships (depth 2–3).

🏷️ Auth & RBAC Performance · ⏳ pending · ➡️ baseline · source

⏳ Pending — Measures JWT verification, session retrieval, and permission matrix resolution overhead.

🏷️ REST API Performance · ⏳ pending · ➡️ baseline · source

⏳ Pending — End-to-end throughput and latency of the unified REST dispatcher.

🏷️ GraphQL API Performance · ⏳ pending · ➡️ baseline · source

⏳ Pending — Resolver execution time and throughput for common queries.

🏷️ Enterprise SEO Suite Audit · ⏳ pending · ➡️ baseline · source

⏳ Pending — E2E audit of Redirect Middleware, 404 Logging, and Sitemap Caching performance.

🏷️ REAL-TIME BROADCAST AUDIT · ⏳ pending · ➡️ baseline · source

⏳ Pending — Benchmarks network-layer broadcast latency (SSE vs WebSocket).

🏷️ WebSocket & Realtime Latency · ⏳ pending · ➡️ baseline · source

⏳ Pending — Benchmarks WebSocket connection/broadcast latency.

Scale · 18 tests
🏷️ Negative Cache Performance · ⏳ pending · ➡️ baseline · source

⏳ Pending — Benchmarks 404-miss response times and cache lookup speedup.

🏷️ Revision & History Growth · ⏳ pending · ➡️ baseline · source

⏳ Pending — Benchmarks performance degradation as document history grows to 100+ versions.

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

⏳ Pending — Long-running soak test to identify memory leaks and GC pressure.

🏷️ Multi-Tenant Performance & Isolation · ⏳ pending · ➡️ baseline · source

⏳ Pending — Stress-tests cross-tenant isolation and security boundary latency.

🏷️ Realistic Mixed Workload · ⏳ pending · ➡️ baseline · source

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

🏷️ GraphQL Load Stress · ⏳ pending · ➡️ baseline · source

⏳ Pending — High-concurrency GraphQL query stress test for resolver efficiency.

🏷️ Bulk Migration & Scale · ⏳ pending · ➡️ baseline · source

⏳ Pending — Measures system ingestion limits and read performance on 10,000+ entries.

🏷️ Million-Row Index Pressure · ⏳ pending · ➡️ baseline · source

⏳ Pending — Measures complex filtering and sorting performance on 100,000+ entry collections.

🏷️ Content Scale Stress · ⏳ pending · ➡️ baseline · source

⏳ Pending — Measures content scan performance on 1,000+ collections under .compiledCollections/test/stress (isolated).

🏷️ Media Upload Stress & Throughput · ⏳ pending · ➡️ baseline · source

⏳ Pending — Measures large file upload throughput, concurrent upload handling, and streaming efficiency.

🏷️ Full Client Journey Simulation · ⏳ pending · ➡️ baseline · source

⏳ Pending — E2E journey: Login -> List -> View -> Edit -> Save -> Realtime. Measures cumulative latency.

🏷️ Concurrency & Race Condition · ⏳ pending · ➡️ baseline · source

⏳ Pending — Verifies atomic consistency and lost-update protection.

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

⏳ Pending — Measures throughput scaling across 10, 100, 1000 documents.

🏷️ Max Throughput — No Throttle · ⏳ pending · ➡️ baseline · source

⏳ Pending — 1000 concurrent writes across 100 docs — no semaphore.

🏷️ Local SDK Throughput · ⏳ pending · ➡️ baseline · source

⏳ Pending — 1000 direct adapter calls — no HTTP, no middleware.

🏷️ Failure Propagation & Fast-Fail Audit · ⏳ pending · ➡️ baseline · source

⏳ Pending — Measures system overhead when downstream dependencies (DB/Redis) fail or timeout.

🏷️ Chaos & Infrastructure Resilience · ⏳ pending · ➡️ baseline · source

⏳ Pending — Simulates 500ms database brownouts and measures CMS availability and stability.

🏷️ Production Day Simulation · ⏳ pending · ➡️ baseline · source

⏳ Pending — Full production day with mixed workload, 100% reliability.

Resilience · 5 tests
🏷️ Circuit Breaker Failover · ⏳ pending · ➡️ baseline · source

⏳ Pending — Measures system graceful degradation when external services fail.

🏷️ Throttling & Backoff Stress · ⏳ pending · ➡️ baseline · source

⏳ Pending — Measures rate-limiting consistency under 10x design load.

🏷️ GDPR Compliance Speed · ⏳ pending · ➡️ baseline · source

⏳ Pending — Measures performance of deep-deletion across all linked tables.

🏷️ Data Residency & Sovereignty · ⏳ pending · ➡️ baseline · source

⏳ Pending — PII blocking and data sovereignty enforcement with cross-region failover.

🏷️ Database Failover & Reconnection · ⏳ pending · ➡️ baseline · source

⏳ Pending — Simulates DB disconnect mid-request — measures circuit breaker activation and reconnection timing.

⏳ Host environment populates after matrix run.

benchmarkperformancesqlite
Was this page helpful?