is doing order data statistical analysis, because the order quantity is too large, the order needs to be preprocessed. At present, the plan I think of is: 1. Keep the daily sales quantity and amount of member stores, but due to the low activity of most member stores, the daily sales of these member stores are 0. in this case, the "meaningless" data of the database accounts for a large part. 2. If you do not keep a record of zero sales for the day, then if you want to rank the sales of member stores within a certain regional time range, it is necessary to jointly query the sales table and the general table of member stores to get the results.
if there are tens of thousands of member stores, tens of thousands of pieces of data will be added every day in solution 1, and most of them are meaningless; if solution 2 is adopted, although the number of new data per day will be greatly reduced (perhaps only a few thousand or hundreds of items), it may also take a lot of time to do a joint survey of rankings.
I don"t know how to solve it in this situation. No, no, no.