Plugins » Katello

Customer has over 9 million rows in their katello_repository_rpms. Checking for content view version list takes much longer than anticipated.
We need to cache to the content counts for a content view version when creating it and have content view version list piggy back of that cache.
We could add a counts with a serializable json to store this information.

Four parts to the story

1) Create a serializable column to store the content counts for a content view version
2) Store the content view counts when the content view is created
3) Make the content view version list use the content counts
4) Write a db migration script to setup the content counts