Regarding List View Threshold limits (LVT), I have done a lot reading and I am starting to wonder even with indexed columns will our current system scale?
What happens if we have a list called Clients and it has 15000 active clients & 3000 inactive clients (18000 items).
- How do I display this data to my users without getting a threshold error?
- How will exceeding the LVT affect other lists with Lookup columns pointing at the Clients list?
- Will a lookup be fine or will it through its own error too or only views on the Clients list itself will require filtering?
Server: SharePoint Foundation 2013 Note: Need a solution that can be done via the web UI or SharePoint Designer. I am not a programmer.