Transaction volume guidelines
There are many variables that influence the scaling of a software solution. The Sterling Order Management System Software is capable of scaling to a significantly higher number of transactions per hour than the Business Intelligence. Sterling Order Management System Software processing rates can exceed the typical capabilities of Business Intelligence during the extract-transform-load (ETL) process, which performs optimally at lower rates.
IBM® provides guidance on how to optimally tune the Business Intelligence. For more information, refer to the Performance Management Section. IBM has many Business Analytics solutions. If your transactional rates are expected to exceed those published in the guidelines, contact IBM to discuss other solutions that may be more appropriate for higher volumes.
Guidelines
- For processing about 20,000 order lines per hour
- You must read, understand and apply recommendations from the Performance Management Section and the Implementation Section.
- For processing about 40,000 order lines per hour or less
- You must read, understand and apply recommendations from the Performance Management Section and the Implementation Section.
- You must also follow the hardware and server recommendations such as ensuring the extractions are directed to read only database (not the main OLTP database).
- You must also have a Business Intelligence administrator to manage the Business Intelligence solution.
- For processing about 40,000 - 60,000 order lines per hour
- You must read, understand and apply recommendations from the Performance Management Section and the Implementation Section.
- You must perform Business Intelligence Load Tests with OLTP running at their targeted peak volumes to ensure the entire solution works.
- Business Intelligence is not recommended above 60,000 order lines per hour.