It seems like I have 2 options for setting up my stats.
No stats data type, only tasks data type for all tasks.
Adding a task simply adds a new line to the tasks database.
When the user wants to view their stats, the app searches for the task data for all tasks, and calculates the stats from that large chunk of data.
Tasks data type, for all tasks.
Stats data type for stats per user.
Adding a task adds a line to the tasks database, and also changes the data in the stats type for that user.
When a user wants to view their stats, the app searches the stats data type, a single line in the database, and returns all the entries without needing to calculate anything (as all calculations happened each time a new task was added).
The second one will clearly be faster, but will require a search for the stats entry for the user every time they enter a new task.
The first one will only need a search when the user wants to view their stats.
It seems that you are saying that the first one will cost significantly fewer WUs? Or am I completely getting the wrong end of the stick? I am finding the whole WU thing very confusing and off-putting…!