In SharePoint online (2013) list will grow up to 3,00,000, currently we only have 100 items. And the default list view throttle in SharePoint Online is set to 5000 limit. By default, If we visit the list, it will open in Allitems.aspx view. So if we go to “All Items view” and set the “Item Limit”, Display Items in batches of the specified size say “1000” then users can navigate the list items in pages, So will this prevent encountering the List view throttle limits?
In other words how can I ensure users to navigate lists with over 3,00,000 items without encountering the throttle limit?
Because my understanding is that SQL will issue a lock, if view generates a query exceeding 5000 items. So by setting “Display items in batches of the specified size say 1000, view will only query for those 1000 items per page. But one of my colleague says even with that setting we will encounter “throttle limits” and navigation to the list will be blocked? If So how to prevent list throttling and enable users to navigate the list items in a large list?
Moving list items to a different list is not an option for us.