We have a Sharepoint list that contains information based on a daily receiving log for our receiving department. When it was set up, there was no archive workflows created, so now this list has grown to over 40000 items.
The issue is that one of the columns is a lookup where we can tie a new item to an existing item that we have already received. Because of the huge number of items, when you click "New Item" it takes forever for it to load all of the Parent Materials. Is there a way that I can trim this up so that it loads faster? I'm already working on creating an archive list for items new items that are added, but that doesn't help for the existing items.
I've looked all over to see if I can clean up the list by manually moving items over two years of age to the archive list, but I can't find anything. Any help would be appreciated. Thanks!