I'm wondering if anyone cleans up the ESP_AMS_VR table. I've recently found that all version of the apps are stored in this table and when you delete an app which removes it from the ESP_AMS_DF table, it does not remove it from the ESP_AMS_VR table.
When you go to download apps it takes noticeably longer than on our prod system and while we do have a good bit more apps in test than prod, I'm wondering what we can do to reduce the time it takes to finish the action and display all apps when you go to download an app.
I've found that about 13,500 records exist in the ESP_AMS_VR table. These records are all ones that consist of deleted applications. Could removing these be beneficial at all? I'm just thinking of how, in my mind the product may act when you go to download an app in the client. I suppose it queries the AMS_VR table and by having a lot of unwanted records, maybe that is the reason behind the slowness, any thoughts?