I have researched a lot trying to answer this question, but nothing seems to work correctly. I have a list that stores tons of values and when interacting with it there is always an acceleration limit message reached.
I've tried solutions like Disable Throttling in one list
The following steps will help to change the view of the threshold of the list view at the web application level.
• Log in to Central Admin.
• Go to Application Administration -> Manage web applications.
• Choose the web application for which you want to change the threshold value.
• On the ribbon above, click on General Settings. That will open a menu, from which you should choose the limitation of resources.
• Change the value of the list view threshold.
Unfortunately, nothing seems to work, so any help is very much appreciated.