Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

CacheSize property

Specifies the size of the cache.

Visual Basic

Public Property CacheSize As String

C#

public string CacheSize {get;set;}

A string specifying the cache size. The default is a null reference (Nothing in Visual Basic) meaning the default of 16 pages is used.

The values for the cache size are specified in units of bytes. Use the suffix k or K to indicate units of kilobytes and the suffix of m or M to indicate megabytes.

For example, the following sets the cache size to 128 KB.

connParms.CacheSize = "128k"

The default cache size is 16 pages. Using the default page size of 4 KB, the default cache size is therefore 64 KB. The minimum cache size is platform dependent.

The default cache size is conservative. If your testing shows the need for better performance, you should increase the cache size.

Increasing the cache size beyond the size of the database itself provides no performance improvement and large cache sizes might interfere with the number of other applications you can use.

If the cache size is unspecified or improperly specified, the default size is used.

•  ArgumentException - The value contained a semicolon (;), or began with either a single quote (') or a double quote (").