I’m trying to create a task-management system that tracks the time spent on tasks. I’ve been using a button in the “task” table to create an entry in my “time tracking” table. I’m calculating the duration from the start time of each entry using Now() in order to see create a timer that shows how much time I’ve spent on a task, even before finishing it.
Turns out the performance of the system degrades quickly as I add more entries. I’ve played around with adding a separate “middleman” table to track time for ongoing tasks and get rid of the Now()-formula in the larger table of tracking entries, but the performance is still poor.
Any ideas of how I can create a time tracker that performs better? Is there any way to inactivate the formula in all rows that have an end time logged?
Here is an MVP with the basic functionality I want: