We want to precalculate counts for some common metrics for usage. We have events, locations, products, etc. The problem is we have millions events/day, thousands of locations and millions of products.

Were trying to precalculate counts for some common queries like 'how many times was product X purchased in location Y last week'.

It seems like we'll end up with trillions of counters for even these basic permutations. Is this a cause for concern?

TIA

-- Darren