2 ms·

Why not keep a count running in the SKU's document?

• tzs 16y ago
  That could work. However, what happens when I'm asked to break down my report by whether the purchasers of the SKU were new customers or returning customers? (Also, a count is not sufficient, since someone might want the report run for a specific date range). I could keep two counts in the SKUs document, of course. It doesn't sound very efficient, though, if the procedure when asked for some new report is that I have to go modify the database document layout to specifically support that new report, then do some kind of back fill, and then modify the code that processes orders to fill in the new stuff as orders are processed. As I said, I didn't get far into NoSQL, so maybe it is a lot easier than it seems to me now.