search

writer-bot / bot

5 stars 7 forks source link

DB cleanup script #27

Open cwarwicker opened 1 year ago

cwarwicker commented 1 year ago

Write a script to clean up some old data in the database we don't need any more, for example old sprint_users records.

Also explore if there's a way to reduce the size of the goals history table, as it is by far the largest.

cwarwicker commented 1 year ago

Done this for sprint_user records. Need to look at goal_history as well.

cwarwicker commented 1 year ago

Also need to clean up sprints which never ended which are sitting as completed=0 in the database.

cwarwicker commented 1 year ago

^ that is done now in f18e27a