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.
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.