Information Retrieval (IR) expert parameters: ir_sql_limit

Parameter

ir_sql_limit

Description

This parameter determines the maximum number of records that a combined IR and SQL query returns from the RDBMS.

This parameter does not affect pure IR queries (queries that only involve IR indexed fields) or pure SQL queries. This parameter only affects queries that involve some fields that are indexed by IR and some that are not.

Valid if set from

Server's operating system command prompt

Initialization file (sm.ini)

Requires restart of the Service Manager server?

Yes

Default value

32767

Possible values

The maximum number of records to be fetched from the RDBMS for a combined IR and SQL query. A value of 0 (zero) means there is no limit.

Example usage

Command line: sm -httpPort:13080 -ir_sql_limit:20000

Initialization file: ir_sql_limit:20000

Related topics

System parameters
Enter a parameter in the sm.ini file
Information Retrieval (IR) expert parameters