Open wishplorer opened 2 years ago
Currently, rewards table is aggregated and hard to get reward by different type without going to transaciton table and parse it.
create a table for reward by type and reward by type per day to aggregate data and preprocess it.
we did it at hotspotty, it's a very very heavy query that it's quite hard to keep up.
Currently, rewards table is aggregated and hard to get reward by different type without going to transaciton table and parse it.
create a table for reward by type and reward by type per day to aggregate data and preprocess it.