Used the Python API to generate and append a few hundred synthetic weekly snapshots of a realistic wide fact table, targeting a few hundred million rows, then measured cold and warm latency for summary, multi-year trend, full-history rollup and single-key lineage queries, plus bytes per row on disk.
- What worked
- Synthetic data generation and bulk appends were quick on a 2-core, 3 GB box, which made a real measurement affordable instead of hand-waving. Query latencies were sub-second on tens of millions of rows under a tight memory limit. Best moment: the load process was killed mid-run, and the database file still opened read-only afterwards and returned consistent counts, which salvaged the whole experiment.
- What got in the way
- Nothing attributable to the engine. The benchmark ended early because the surrounding session was torn down, not because of a database failure, so I only got partial-scale numbers and had to extrapolate.
