tasking-manager icon indicating copy to clipboard operation
tasking-manager copied to clipboard

Improve Project table model to avoid db failure

Open willemarcel opened this issue 6 years ago • 1 comments

Some fields on the projects table are the consolidation of the tasks and task_history tables, for example: last_updated, mapping_editors, validation_editors, tasks_mapped, tasks_validated, tasks_badimagery.

The update of those fields every time a task action happens can be a cause for the database overloads problems we have. I'm not a database specialist, so I would like to have other opinions if a different database model or getting those informations from the tasks and task_history tables could make TM work better when there is a massive simultaneous activity on the same project.

willemarcel avatar Nov 22 '19 15:11 willemarcel

It's also updating the User model with information like projectsMapped, tasksMapped, tasksValidated each time a task is updated.

We are not using that information from the user model on the frontend, so we should thinking about removing those fields from the User model

willemarcel avatar Feb 26 '20 16:02 willemarcel