Intellicus Enterprise Reporting and Business Insights 19.1

Memory Management

0 views June 28, 2020 0

Request Queue Size

Report server places all requests in queue before executing them.  This property is to set maximum number of requests that can be queued.   After the queue is filled, server ignores all client requests, until number of requests in queue is reduced to a number less than the property value.

Specify an integer value that is greater than zero.

New value set for this property will come into effect after server re-start.

Default: 1000

Example: QUEUE_SIZE=1000

Data Source Fetch Size (rows per fetch)

This is the number of records to be fetched from the data source at a time (in one read).  Specify a positive integer.

Default: 50

Example: DATA_SOURCE_FETCH_SIZE=50

Note: Value set in this property will not remain effective for MySQL database.

 

Sort Area Size Per Exec (rows)

This property is to set the number of records that can reside in memory for all sort threads of a report.  Property can be given a value more than 0.

Default: 600

Example: SORT_AREA_SIZE_PER_EXEC=600

Note: Sort Area Size Per Exec property will work in coordination with Sort Threads Per Exec property explained later on the page.

 

Scheduler Job Dispatch Queue Size

This property is to set the maximum number of jobs that can be spawned at a time.  A valid value is zero or any positive integer.

New value set for this property will come into effect after server re-start.

Default: 50

Example: SCHD_JOB_DISPATCH_QUEUE_SIZE=50

Chunks in Memory

Number of report pages chunks that can reside in memory. Report server will stream each chunk to the viewer as soon as it is rendered. Specify a value that is more than 2.

Default: 4

Example: CHUNKS_IN_MEMORY=4

Output Buffer Size (nKB or nMB)

The maximum size of MEMORY to be used to store report output chunks. Specify in terms of MB or KB.

Default: 2.5 MB

Example: OUTPUT_BUFFER_SIZE=2.5MB

Clone User System Params

This property is defined to enable/disable the cloning of User & System Parameters across the detail sections. The cloning is required only if this installation is upgraded from version 3. Configure Disable for newer installations for memory efficiency.

Default: Enable

Example: CLONE_USER_SYSTEM_PARAMS=Enable

Repeat Report Exec Request

This property defines what to do if the server receives request of a report that is being presently served.  If the property is set to Allow All then it will allow all the report execution requests.  If it is Deny New, then server will not accept the newly received request.  If it is Prompt Cancel portal will prompt the user to cancel new request or request that is presently being served.

Default: prompt_cancel

Example: REPEAT_REPORT_EXEC_REQUEST=prompt_cancel

IRL Cache Size

This is the maximum memory that can be used for IRL (report layout) cache.  This can be specified in terms of number of IRLs, or memory size (KB, MB).

Default: 10

Example: IRL_CACHE_SIZE=10

Sort Threads Per Exec

This is the number of threads to be created (per report request) at runtime to perform sorting of records. This property is hot deployed.

Default: 4

Example: SORT_THREADS_PER_EXEC=4

Utility Thread Pool Initial Size

Utility threads are used to carryout internal processes by Intellicus Report Server.  This property defines initial size of utility threads.

Default: 5

Example: UTILITY_THREAD_POOL_INITIAL_SIZE=5

Note: If all the threads are busy, new threads will be automatically created.

 

Utility Thread Pool Purge Time (seconds)

This property defines the waiting time for an extended thread (created on demand post-initialization) from the pool after which it will be purged.  Specify value in seconds.

Default: 50

Example: UTILITY_THREAD_POOL_PURGE_TIME=50

Field Lookup Max Values

Count of Maximum Lookup values fetched from database for a Query Object column is configurable.  This will reduce the loading time of a query object in Ad hoc wizard/Run and of lookup Values.

Default Value=2000

Example: FIELD_LOOKUP_MAX_VALUES=2000