I was thinking, we currently have 86 human player teams in Bulgaria and 250 bot teams, some of which have 100+ players on their rosters. If we assume that a bot team needs 10-12 players to operate just fine, this calculates to ~15-20 000 bot players that nobody needs or cares about in Bulgaria only!
Considering Bulgaria amounts to a little over 0.5% of BB user population, a very rough estimation would be that there are over 3 million totally useless bot players active right now. Another speculation - if once again we assume that a normal human team has 12-15 players, for 13000 active teams this amounts to roughly 200 000 active players in human-controlled teams.
Now it looks so shocking that I must admit I myself do not believe my calculations are correct. Maybe Bulgaria is just s special case, maybe those numbers are not right but I doubt they are that much far off.
It would seem that 90+% of the players that you guys have in your DB are nobody-cares-about bot players. Now those players have fully accessible profiles with history, stats and all there is... A huge amount of useless data!
If you were to design a simple algorithm to just pick the 10-12 best/youngest etc players of every bot team and remove all the rest in the beginning of every season I think this will be a big relief to the DB.
BBB: 2 (S37 S38); Top tier: 7 (S35 S36 S37 S38 S39 S41 S63); Cup: 9 (S25 S35 S36 S37 S38 S39 S40 S41 S61)