4

Not sure if this is a bug or something; I have a List that contains around 12,000 items in SharePoint Online. I was experimenting with it and it seems to still show items using a View with Paging enabled? I have paging of around 1,000 items.

I thought it shouldn't work, cause Paging loads everything? I have another list that contains 6,000 items, but the view is to show all 6,000 items at once. This one shows me the expected List View Threshold.

Is this weird or is it really working as intended? I thought just having >5,000 items in a list will already pose some problems?

Edit: I have only 2 columns: Title, and Body.

3

List view threshold means the maximum rows a single SQL command can read. When you have paging, SQL restricts its reading with the limit functionality added to it. Therefore in your case it would only query 1000 rows at once.

Another thing that I noticed during my researches is that when there is a lookup column, the whole composite table(all rows) is joined before reading the rows. In your case, you do not have lookups so will not be a problem.

Edit: When you filter or group by the lookup column it creates the whole table before displaying the results. Otherwise not.

  • Are you sure that when we use paging, row limit defaults to 1000 unless specified? – variable Aug 13 '14 at 4:31
  • Reg. your 2nd point, you mean when there is lookup column in the view field or where clause ? – variable Aug 13 '14 at 4:32
  • Thanks Malin. That's an interesting one; there seems to be differing answers regarding Paging. Others are saying that it still queries ALL of the items, just hiding some of it. Might it be that the "All Items" default view uses Indexing by default? – Water Aug 13 '14 at 6:24
  • Wait I found some good article about paging. Still could not locate it again. – Malin De Silva Aug 13 '14 at 6:59
  • 1
    Might be obvious to some people, but just wanted to add a quick note on this: If you're filtering your view based on multiple fields joined with an <And>...</And> clause, you must get the number of results below 5000 with the first field to prevent the threshold issue. Seems like it builds the table by filtering with the first field, then filters that table based on the second. – Charles Grunwald Jul 19 '16 at 21:39
3

You are using the SharePoint Online and you have only 2 column in the lists. Another question are you site collection admin.

If you are Site collection admin then you can see all items as LVTH is different for site collection admin as compare to other users. For Admin by default is 20,000 items while for others are 5000 items.

One thing keep in mind, you have million of items in List but you cannot view more than 5000 items( not for admins) unless you designed it a way which is recommended by MSFT. Use the Managed Metadata column, index column, filter the views etc.

Check the below link for more information.

http://support.microsoft.com/kb/2759051/en-us

  • Ahhh, yes I am Site Collection Admin. Ok, I will experiment with 20,000 items. Will let you know what happens :) – Water Aug 26 '14 at 0:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.