SQL parameters: sqlbatchcount

Startup parameters change the behavior of the Service Manager server. You can always set a startup parameter from the server's operating system command prompt.

Parameter

sqlbatchcount

Description

This parameter defines the number of records the Service Manager server retrieves from the RDBMS during a single select call. You can use this parameter to reduce the number of interactions between Service Manager and your RDBMS. Rather than selecting and returning each record from a record list individually, Service Manager can select and return a batch of records in a single SELECT statement.

Valid if set from

Server's operating system command prompt

Initialization file (sm.ini)

Requires restart of the Service Manager server?

No

Default value

64

Possible values

Number of records

Example usage

Command line: sm -httpPort:13080 -sqldb:dbserver -sqlbatchcount:72

Initialization file: sqlbatchcount:72

Related topics

System parameters
Enter a parameter in the sm.ini file
Database parameters