I think that's going to have to wait for the new stats service. I'm cheating by using index-only scans, but that doesn't change the fact that there are millions of core downloads that have to be processed multiple times. We need to persist aggregates, and doing that in SCA's DB at this point seems like a wast of time.
I think that's going to have to wait for the new stats service. I'm cheating by using index-only scans, but that doesn't change the fact that there are millions of core downloads that have to be processed multiple times. We need to persist aggregates, and doing that in SCA's DB at this point seems like a wast of time.