10 TimesTen Database Performance Tuning

An application using TimesTen should obtain an order of magnitude performance improvement in its data access over an application using a traditional RDBMS. However, poor application design and tuning can erode the TimesTen advantage.

There are factors that can affect the performance of a TimesTen application. These factors range from subtle, such as data conversions, to more overt, such as preparing a command at each execution.

This chapter explains the full range of these factors, with a section on each factor indicating:

• How to detect problems.

• How large is the potential performance impact.

• Where are the performance gains.

• What are the tradeoffs.

The following sections describe how to tune and identify performance issues:

Note:

You can also identify performance issues by examining the SYS.SYSTEMSTATS table.

• System and Database Tuning

• Client/Server Tuning

• SQL Tuning

• Materialized View Tuning

• Transaction Tuning

• Recovery Tuning

• Scaling for Multiple CPUs

• XLA Tuning

• Cache and Replication Tuning

For information on tuning TimesTen Java applications, see Java Application Tuning in the Oracle TimesTen In-Memory Database Java Developer's Guide. For information on tuning TimesTen C applications, see ODBC Application Tuning in the Oracle TimesTen In-Memory Database C Developer's Guide.