-cr dbeng12/dbsrv12 server option

Reloads (warms) the cache with database pages using information collected the last time the database was run.

Syntax

{ dbeng12 | dbsrv12 } -cr{ + | - } ...

You can instruct the database server to warm the cache using pages that were referenced the last time the database was started (page collection is turned on using the -cc option). Cache warming is turned on by default. When a database is started, the server checks the database to see if it contains a collection of pages requested the last time the database was started. If the database contains this information, the previously-referenced pages are then loaded into the cache.

Warming the cache with pages that were referenced the last time the database was started can improve performance when the same query or similar queries are executed against a database each time it is started.

-cr dbeng12/dbsrv12 server option

Syntax

Applies to

Remarks

See also