Configure the Maximum Number of Rows in a Query
Scenario/Problem: You need to modify the maximum amount of rows in a query.
Solution: Use the RowsMax
parameter with the Set-SPAccessServiceApplication
cmdlet.
The RowsMax
parameter has a default value of 25000
and determines the maximum number of rows a list that participates in a query can contain and/or the maximum number of rows that can be contained in the results of the query. The valid range of values for this parameter is 1
to 200000
. Listing 23.6 shows a sample modification of the maximum number of rows.
Set-SPAccessServiceApplication -Identity "Access Services"-RowsMax 10000
Although lists and libraries have been optimized in SharePoint ...
Get PowerShell™ for SharePoint® 2013 How-To now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.