We're currently facing a concern about the potential size of our Lists / Document Libraries which may well reach up to a Million.
I read that a single List / Document Library can store up to 30,000,000 items but has a List View threshold of 5,000, which essentially forces you to think of storing your items on a 5,000 limit per folder / view or what approach you use.
I would like to ask, what if there is a possibility to NOT be able to group the items in some way? For example, the only column used is an ID (WIN-xx) where xx is an incrementing number. There are no categories available to be able to sort them into folders or views. I can probably group them to show only the 5,000 recent items, but how then can I show the items that exceed the 5,000 item limit? For example, I want to reference the "old" items.