February 2013
Intermediate to advanced
304 pages
8h 26m
English
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.
Listing 23.6. Changing the Maximum Number of Rows
Set-SPAccessServiceApplication -Identity "Access Services"-RowsMax 10000
Although lists and libraries have been optimized in SharePoint ...
Read now
Unlock full access