|
change to resetting skill uses
can we have a total usage and total percent and then a percent since the last reset. so we track both? This way we can track total actions.
Don't want to tell you how to code...but this is how I would handle it.
When someone resets, update a history table with total skills and add to it, then update the current table to zero.
seems like you run a job that updates the rankings tables. Then that job can add up both tables. Even if we get 50,000 people a straight sql statement with a join between the two tables should only take 2-3 seconds to run at most.
|