01 / Query optimization
30+ collections. Thousands of field combinations.
A query optimizer that did only the work each report needed.
Define · Build · Check · Learn
- 01
Define
Reports crossed 30+ data collections and thousands of field combinations. Repeated database work and memory failures made them take up to three days.
- 02
Build
I built a query optimizer that chose only the steps each report needed.
- 03
Check
Reports finished in about two minutes. The result gave teams answers without a days-long wait.
- 04
Learn
Make the work fit the question. A flexible report should not have to run every possible query.