Certain information objects, for example an information object that aggregates data over a very large number of rows, take a long time to return data rows and place a heavy load on production databases. You can reduce information object execution time as well as the load on production databases by caching the information object. You cache the data rows returned by an information object in a single table in the cache database. A cache database must be of one of the following types:
Information object caching is managed by the Actuate BIRT iServer System Caching service For more information about the Caching service, see Configuring BIRT iServer.
|
In Information Object Designer, create a cache connection definition. A cache connection definition defines the connection properties for the cache database.
|
|
|
In Information Object Designer, create a cache object. A cache object is associated with a table in the cache database.
|
|
|
In Management Console, activate the cache object. Activating the cache object creates a cache table.
|
|
|
In Management Console, populate the cache table by running a job for the cache object. You should periodically refresh the data rows in the cache table.
|
This chapter explains how to perform the first and second tasks. For information about the third and fourth tasks, see Managing an Encyclopedia Volume.
