A made-up story
Picture a trucking company. Dispatchers use one system all day, and managers run big reports on the same system every morning.
What's going wrong
When the reports run, the dispatch screens freeze. Someone suggests buying a full analytics platform.
What they have today
- One database for dispatch and reporting
- Years of shipment history
- A reporting tool the managers like
What we can't ignore
- Dispatch can't slow down
- Reports must stay accurate
- Budget for a big new platform is uncertain
The choices
- Worth a look
A bigger database server
Helps for a while, at a higher monthly cost.
- Our pick
Fix the slowest reports, and give reports their own copy
Reports read from a copy, so dispatch never waits.
- Maybe later
A full analytics platform
Worth it once reports need data from several systems.
