Actions
Bug #28427
closed
Content view versions list has slow query for package count
Difficulty:
Triaged:
Yes
Bugzilla link:
Pull request:
Description
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
Updated by The Foreman Bot about 5 years ago
- Status changed from New to Ready For Testing
- Assignee set to Partha Aji
- Pull request https://github.com/Katello/katello/pull/8468 added
Updated by 
Updated by
Updated by The Foreman Bot about 5 years ago
- Fixed in Releases Katello 3.15.0 added
Updated by Partha Aji about 5 years ago
- Status changed from Ready For Testing to Closed
Applied in changeset katello|b2c46015f0790bd4cb0b9e3a7699ef6852240530.
Actions