ODBC Driver for Microsoft SharePoint

Build 23.0.8839

DisableFilterLimit

Microsoft SharePoint natively supports listing up to 5000 records as they appear in your list filter. Enable this property to pull more than 5000 records from the list filter at the cost of additional performance overhead.

データ型

bool

デフォルト値

false

解説

Regardless of whether this property is set to true or false, for list filters with 5000 or fewer records, server-side processing of list filter queries is supported by Microsoft SharePoint, leading to the fastest possible performance.

When this property is set to true and the list filter exceeds 5000 entries, the 本製品 will process the query filters client-side, which has an extra cost to performance.

However, if this property is set to false and the list filter exceeds 5000 entries, the 本製品 will query from the list itself (as opposed to the list filter). This causes the set of columns in the query result to reflect the columns in the list instead of the list filter.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839