Hi
We have team_sets_modules table size over 5GB and is growing rapidly. How can we reduce size of that table? Are all those records necessary?
By documentation it says:
-
This table is used to manage team sets and keep track of which modules have records that are or were associated to a particular team set.
When i run queries on that table:
/* How many records with team_set_id are? i get about 4000 */
SELECT * from team_sets_modules where deleted=0 and team_set_id <>"";
/* How many records without team_set_id are? i get all other records, millions of them */
SELECT * from team_sets_modules where deleted=0 and team_set_id IS NULL;
I see that majority of records in that table only have id and module name, team_set_id is empty. Can we remove records without id?
