I have done some research and I think I am ok, however I cannot take the risk of not knowing for sure. I have just developed a site that will host 8000 events per year (8000 List items) and there will be around 120,000 members (120,000 List items) at those events.

I have set up my regional column (single choice) to be indexed and I have a query string filter configured to filter based on the region you choose. I have found plenty on ensuring you have a filter on an indexed column, however they are always using basic list filters in the examples. Will a query string filter work to keep my events list under the list view threshold?

Second part for the members, no event will ever hold more than 1000 people in it. I have another query string filter set up to filter the member's list based on the event-ID. Will the query string filter keep me under the threshold? I think I will index the Event-ID column as this is the unique key that brings this entire system together.

Your Answer

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

Browse other questions tagged or ask your own question.