Dynamic Load Performance

Dynamic loading of a single cache instance based on a primary key search of the root table has faster performance than primary key searches on a child table or foreign key searches on a child table.

See Dynamic Cache Groups.

Dynamic loading of multiple cache instances may have faster performance than loading single cache instances. See Dynamically Loading Multiple Cache Instances.

If you combine dynamic load operations with autorefresh operations, you may experience some contention. See Improving Performance for Autorefresh Operations for details on how to improve your performance in this situation.

There can be a performance cost when opening a new connection for a dynamic load operation. You can reduce the cost of opening new connections by creating a cache connection pool. You may want to use a cache connection pool if your application requires frequent dynamic load operations that would create too many open connections to the Oracle database. See Managing a Cache Connection Pool to the Oracle Database for Dynamic Load Requests.