Hello, i had a similar problem. The solution was to use composite content views. A content view containing OS packages, snapshotted every 3 months, and the repository with higher refresh rate on a content view updated when required. The CCV was then refreshed when a CV was updated, using as reference the latest version.
How often do you refresh the content view? I’ll need to update it every 30 minutes, this means around 17000 versions a year. Do you have any experience with this high number of CVs?