Export (0) Print
Expand All
Expand Minimize

Large Level Threshold Property

SQL Server 2000

Large Level Threshold Property

This property determines the point at which a level is too large to be sent to the client application in a single piece.

Property Name

Large Level Threshold

Property ID

DBPROP_MSMD_LARGE_LEVEL_THRESHOLD

Remarks

Use this property to help manage client application memory usage. If the number of members in a level is below the threshold you set in this property, it is sent to the client application in one piece. If the number of members in a level is equal to or more than this threshold, the level is broken into smaller groups, which are sent as needed. Levels that contain a number of members that is less than this property's value are sent to the client application. If a level contains a number of members that is greater than or equal to the value of this property, the level is incrementally sent from the server to the client application.

The default value is set on the server in the Large level defined as box in the Properties dialog box for the server. The minimum value for this property is 10. Setting this property to a value less than the minimum causes the value to be set to the minimum, without error.

This property's value is used when a session is established, and it cannot be changed during the session.

The default value for this property is 1000.

See Also

Environment Tab (Properties Dialog Box)

Show:
© 2014 Microsoft