This guide describes how to use Pentaho tools to optimize the speed and efficiency of the Pentaho Suite for your business. This guide also describes best practices and reference information for analysis, reporting, data integration, and data mining.
Performance tuning is different from configuration. While initial configuration of your system involves logically setting up each Pentaho component for basic functionality, performance tuning aims to locate, identify, and remedy bottlenecks in your system performance. While configuration is typically completed when you initially set up your system, tuning is often performed in response to problems which arise during the preproduction and production stages.
Each method described in this guide applies to a specific situation and should be properly evaluated for success in your system prior to implementation. Some of these performance tips remove functionality, and in some cases security, from the instance of your Pentaho Server. Others will assign more system resources to the Pentaho Server, which could in turn impact other services running on the same machine. You have to determine the best compromise between performance on one end and functionality, security, and resources on the other.
The tuning suggestions listed here are meant as an initial set of self-service tasks for improving the performance of the Pentaho Suite. More advanced techniques may improve performance, but require surgical changes to the code or software. These techniques are not included in this section for safety reasons. A Pentaho partner or consultant can assist you with more advanced performance improvements, if needed.
The Pentaho Tuning Guide includes performance tips for the following components: