Sorry to make two threads. I've been trying to chase down a reason for a Perch 3 upgrade to have gotten a lot slower, and I've noticed that this particular client has over 3050 individual tags for assets. As a result anything that touches assets appears to be running very slowly (30-40s load times). The UI for the assets panel also seems to be struggling with the number of elements in the filter tab. I've removed the data and this does remove the delay.
This is after only a few months of the client managing their site so I am a little concerned about this over the long-term.
I wouldn't consider this a criticism, as no UI or DB should really be handling that many items well - I'm just wondering whether there is something that could be done as a hard limit or a paginated system that could cope better with this volume. It looks like a lot of the tags have come from images uploaded from Shutterstock.
At the moment I am considering truncating the resources_tags table to complete the upgrade, otherwise we are a bit stuck as adding non-text content is as a bit of a standstill.