Performance
NGS-IQ is designed for the IBM i. Your queries run in batch and the software is designed to encourage offline development, presentation, and analysis. For example, when using IQ Client, you need not be signed on to the IBM i except when transferring a query definition to or from your PC. When using the SmartView OLAP module, you work offline over a read-only set of data that you can format, pivot, chart, highlight, and drill into without consuming resources on your IBM i. NGS’ Business Performance Dashboards utilize the Adobe Flash Player to provide you with dynamic, graphical presentations of query output stored on the IBM i's IFS. The queries that deliver the data to the IFS can be run from a job scheduling utility or on demand, but users navigating through a performance dashboard to view the various charts, tables and other elements in the model use virtually zero i5/OS resources.
In contrast, except when using the separately licensed and priced Active Reports feature, QU2 users need to be connected to the IBM i when developing and viewing reports. IBM spokespeople have provided varying information about the CPW and disk arm requirements of QU2. Whenever presenting DB2 Web Query, IBM representatives talk at length
about the performance benefits of the IBM i SQL Query Engine (SQE) over
the Classic Query Engine (CQE). These discussions typically overlook
other factors that impact query performance. In fact, many customers
have found that queries created and run through DB2 Web Query actually
take dramatically longer to process and consume far more system resource
than when run by Query/400. DB2 Web Query generally requires a much
faster processor than Query/400 to achieve comparable results.
Return to First Page
Legal Notice: NGS believes all of the above information is accurate at the time of publication. However, IBM software products and marketing policies are subject to change at any time, without notice. Speak to your IBM or IBM Business Partner representative for current product, pricing, and support information. We welcome your comments.
Last Updated: October 16, 2009 |
