+- Official Battle Tanks Community (https://btanks.net/forum)
+-- Forum: Competition & Tournaments (https://btanks.net/forum/forumdisplay.php?fid=38)
+--- Forum: League (https://btanks.net/forum/forumdisplay.php?fid=43)
+--- Thread: League optimization (/showthread.php?tid=3041)
League optimization - eSVau - 2012-01-13
We've optimized league, league db and bot db.
The bots has known about 130'000 distinct account which bloated it db about 250MiB, after removing expired accounts (older than three month) only 10000 distinct acounts are left.
The concerning table has been reduced by 60% - original more then 2'000'000 entries.
In league db old accounts will be marked as expired.
Stats and old account can't be captured after they are expired and expired accounts has to requalify themselfs.