I have a Sharepoint 2013 task list with 5001 items in it. I have talked with the department that uses it about limiting the size by clearing out old items, but that is probably a little ways off.
When I ran into the size limit, I increased the limit temporarily and added an index and then brought it back down to 5000. That worked fine to allow me to view the list. However, I could not open an item from the list to edit it unless the view threshold was brought back up above 5000.
What is the solution for this?
I should say that this particular list is used by about 10-15 people at a time, max.
Edit: Here is the exact error message that showed up in the Event Log.
The form template failed to load. (User: 0#.w|domain\username, Form Name: Template, IP: , Request: https://home.domain.org/Units/unitname/SitePages/Home.aspx, Form ID: urn:schemas-microsoft-com:office:infopath:list:-AutoGen-2014-10-24T20:13:58:284Z, Type: DataAdapterException, Exception Message: The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator. The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator.)