Dataset

Property Name	Description
General
Data Source Name	Specifies the name of the data source. This property is read only.
Query Name	Shows the name of the query in use. This property is read only.
Others
Data Driver	Specifies the cached query result file as the data resource. Usually used for support purpose. The input format for cached query result file is as follows: `jrquery:/jet.universe.resultfile.UResultFileResultSet;Fullpath_of_cached_query_result` Data type: String
Maximum Records	Specifies the maximum number of records you want to display for all of the data containers using this dataset. The default is to display all the records. Data type: Integer
Security
Security Policy Name	Specifies the name of the data source security imported from the catalog. Choose a security policy from the value drop-down list. Data type: String Note: Column-level security (CLS) is not supported on library component at present, so for a library component, only the data source security policies which have not been defined with CLS will be available in the value list.
Data Buffer
Maximum Page Number	Specifies the maximum number of pages in the data buffer. Data type: Integer
Records per Page	Specifies the number of records in each page in the data buffer. Data type: Integer

Property Name

Description

General

Data Source Name

Specifies the name of the data source. This property is read only.

Query Name

Shows the name of the query in use. This property is read only.

Others

Data Driver

Specifies the cached query result file as the data resource. Usually used for support purpose.

The input format for cached query result file is as follows: jrquery:/jet.universe.resultfile.UResultFileResultSet;Fullpath_of_cached_query_result

Data type: String

Maximum Records

Specifies the maximum number of records you want to display for all of the data containers using this dataset. The default is to display all the records.

Data type: Integer

Security

Security Policy Name

Specifies the name of the data source security imported from the catalog. Choose a security policy from the value drop-down list.

Data type: String

Note: Column-level security (CLS) is not supported on library component at present, so for a library component, only the data source security policies which have not been defined with CLS will be available in the value list.

Data Buffer

Maximum Page Number

Specifies the maximum number of pages in the data buffer.

Data type: Integer

Records per Page

Specifies the number of records in each page in the data buffer.

Data type: Integer

Notes:

The properties should be set according to different databases, namely, different databases may have different configurations of data buffer.
If the library component runs in a different environment, the properties should be specified again.
As tested, if enough physical memory is available, and you know the total number of records in the dataset, then you can set Records per Page approximate to the total number of records to achieve better performance. Maximum Page Number is related to the library component, and should not be very large.
The size of data buffer should be less than the available physical memory.
The Heap Size should be set when the data buffer is quite large.