2012-01-13, 20:38:08
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.
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.
Marvin Wrote:The first ten million years were the worst and the second ten million years, they were the worst too. The third ten million years I didn't enjoy at all. After that I went into a bit of a decline