Scale & performance
CommissionSight is built for books of every size — from a 400-member boutique agency to enterprise brokerages with millions of members across many carriers and years. This page explains how it scales and what to expect.
Your book scales to millions
Every account gets its own dedicated database. Your statement and member data lives only there — never co-mingled with another customer’s — and it’s reported through indexed, paginated queries plus precomputed period rollups. That means dashboards and reports stay fast whether your book is hundreds or millions of members:
- Storage — each account’s dedicated database comfortably holds millions of member-records across carriers and periods.
- Reporting — the results grid is paginated, comparisons run as indexed joins, and the green/yellow/red rollup for a period is precomputed, so reading it is effectively constant-time.
- Growth — adding carriers, periods, and members doesn’t slow the platform down.
Statements ingest in seconds
Statements are ingested per carrier, per period. A statement is uploaded, queued, and processed asynchronously on the edge: parse → map → score → compute month-over-month deltas. Typical carrier statements — from hundreds to tens of thousands of rows — ingest in seconds, and re-running a period is idempotent (identical results, no double-counting).
Practical guidance for very large statements
A single statement is processed in one pass, so the practical sweet spot is up to roughly tens of thousands of rows per carrier statement — which covers essentially every real carrier statement. If a single carrier sends you an exceptionally large extract (hundreds of thousands of rows in one file), split it the way the data is naturally organized — by period and/or sub-carrier/plan — and upload the parts. Each part scores independently and rolls up into the same book.
This is a per-statement consideration only. Your total book size is unbounded: a brokerage with millions of members simply has those members spread across many carriers and monthly statements, each of which is modest on its own.
In short
| Dimension | Scales to |
|---|---|
| Members across your whole book | Millions |
| Carriers / periods / history | Unbounded |
| Reporting & comparisons | Fast at any book size (indexed + paginated + precomputed) |
| Rows per single carrier statement | Tens of thousands per upload; split exceptionally large extracts by period |