Limits
Numbers for this stack.
Small path (DuckDB-WASM)
| Constraint | Value |
|---|---|
DuckDB memory_limit | 64 MB |
| Threads | 1 |
| Parquet working-set gate | 48 MB |
| WASM binary | ~41 MB (~9.9 MiB gzip) |
| Paid Worker script cap | 10 MiB gzip |
Past the gate → place on container, same R2 folder. See Scaling.
Normal path (Container)
Bigger RAM, multi-core, full DuckDB. Cold start is slower. Sleep clears local cache. Next query warms up from R2 again.
Huge path (R2 SQL)
engine: "r2sql". Pay per TB scanned. Needs a token. Not for interactive dashboards.
Rough fit
- WASM: TPC-H SF0.1, ClickBench 1M, tiny demos
- Container: interactive SQL on larger files
- R2 SQL: rare huge scans
Platform
Workers Paid (WASM). Containers enabled (native DuckDB). R2 + D1.