I have a SharePoint List that contains approx 14K items. I have added a link to a page that redirect to a view in this list with a predifined filter on one field (filter added to the URL).
The view is taking approximately 3 minutes to load (there is paging at 30 items per page). Interestingly, without the filter in the query it only takes few seconds.
I have run the Running DBCC Check with rebuild but this did not have any effect. The obvious answer would be to add a SharePoint index to this field. But this issue is just one example that I have. I don't wont to add indexes to all fields.
The AllUserData table has approximately 800,000 rows.
I would like to know whether this a known issue, or whether I could apply some performance optimization to resolve this issue.
Another problem that I have is that when I use the "Show Filter Options" in a SharePoint column, it takes several seconds to load the filters, and sometimes it even times out.
Any assistance would be greatly appreaciated.