As you Test a Pentaho Data Service, you might notice certain bottlenecks, or parts of the transformation that could run more efficiently. If you want to improve the performance of your data service, apply an optimization technique. Some techniques are specifically designed for Pentaho Data Services. See the Administer Pentaho Data Integration and Analytics document to learn about other general design and optimization techniques that can improve the performance of your transformation.
| Optimization Technique | When to Use |
|---|---|
| Service Cache |
For a regular data service only, adjust how long data results are cached. Consider using this technique if either of the following situations apply:
Note: This optimization technique is not available for a streaming data service. It
will not appear as an optimization tab if Data Service Type
is set to Streaming.
|
| Query Pushdown |
Handle input step queries at the source. Consider using this technique if both of the following situations apply:
|
| Parameter Pushdown |
Handle step queries at the source. Consider using this technique if both of the following situations apply:
|
| Streaming Optimization |
For a streaming data service only, adjust the maximum number of rows and elapsed time to produce a new streaming window for processing. Consider using this technique if you are creating a data service from one of the following streaming data steps:
Note: This optimization technique is not available for a regular data service. It will
not appear as an optimization tab if Data Service Type is set
to Regular.
|