My list has 5129 items but I have increased threshold limit up to 5 lac in SharePoint on-prem environment. When a normal user tries to apply a filter to the list the loads very slow. But it not happening using system account. It option loads fast using system account. Also, there are only 10 options in the filter

enter image description here


Are you using item level permissions on the list?

A System account will bypass permission checks on a list and that could explain the performance gain. Otherwise, get a fiddler trace and check where the time is wasted...

Also you could consider indexing the field in question for a better performance... The filter has no clue that there are only 10 items available.

  • It was working fine before 5000 items I guess. Also, Indexing is done already. I don't know how to use fiddler and trace. – hitesh ramani Mar 20 '18 at 13:05
  • Dont mess with the list view limits. They can cause SQL lock escalations. And are you using item level permissions? – Heiko Hatzfeld_MSFT Mar 20 '18 at 13:09
  • Yes, Item level permissions are there. Also, my data is 5137 also it is increasing day by day. Please Help – hitesh ramani Mar 20 '18 at 13:29
  • Have you tried indexing the field? What field type is it? Maybe move it to a MMS field and use that as an external filter? – Heiko Hatzfeld_MSFT Mar 20 '18 at 13:33
  • My first solution was indexing also Those columns are of choice field. I am new in SharePoint, Don't know much about MMS field and external filter? – hitesh ramani Mar 20 '18 at 13:43

You can narrow down this issue as the following:

  1. clear the browser cache.

  2. Clear SharePoint Configuration cache.

  3. Run->IISRest.

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.