CASE FILE
Hobarts CMMS
A full maintenance-management platform built and maintained single-handedly — procurement, inventory, multi-stage orders and a role-based access system.
1,000+Orders / month
700ms — 1.3sQuery time
5Modules
The pipeline problem
Each order had to resolve its parts, vendors and pre-orders in a single read. Done naively that is four round trips per row, and the list view was pulling a thousand rows a month.
After restructuring the aggregation stages and indexing on the join keys.