Fix footprint time threshold calculation logic - Githubissues

mapswipe / python-mapswipe-workers

MapSwipe Back-End

https://mapswipe-workers.readthedocs.io

Apache License 2.0

26 stars 10 forks source link

Fix footprint time threshold calculation logic #869

Closed thenav56 closed 1 year ago

thenav56 commented 1 year ago

Address https://mapswipe.slack.com/archives/C03GP23EJPP/p1687289297561789

This user shared that they "left MapSwipe open" on Sunday and now his stats are showing 22 hours.

Deployment steps

Run project groups data calculation (Runtime: 5-6 hours for Database with 8CPU 16GB VM)
```
time docker compose run --rm django ./manage.py update_project_groups_data
```

Reset aggregated tracking point

TRUNCATE TABLE aggregated_aggregatedtracking;

Run aggregated data calculation (Runtime: 13-15 min for Database with 8CPU 16GB VM)
```
time docker compose run --rm django ./manage.py update_aggregated_data
```