@keith In american-english, yes it’s “e.g.,” in british-english - it isn’t…
Ha ha ha. Anyway,
I guess I’m asking - if I have a tasks table that has 2 million records, what is the best way to show tasks in the screen I provided:
Is it okay to ‘Do a search for’ Tasks where user = current user and status is not completed
Would it be better to have a list of tasks on the user, and Get Current Users tasks, and then have a backend process that updates manages the list to only be current tasks.
Tasks aren’t unique. Sure you could assign me a task “complete your profile”. How is that unique? It’s just the task “complete your profile”. How could there ever be two million of these? I suspect you’re being a dumb dumb.
Could two million users have uncompleted profiles? Sure. But that’s all the same Task.
Well I had imagined I would need to create a record for every occurrence of that task, so that I could see what each individual’s status is? How would you approach this? Happy to keep talking in riddles but it seems you have a good idea on what I should do here.