The short-term solution may be removal of some features, but the long-term solution is to get a few more servers. It will cost chess.com money, but if they keep removing features like this then members will be less inclined to purchase premium membership.
Agreed... I reaaaaally hope the average rating of win/loss/played actually does come back once they've found solutions. A player's rating is useless to me otherwise.
The short-term solution may be removal of some features, but the long-term solution is to get a few more servers.
it's not a matter or more servers. it's a matter of re-architecting the DB. we do need to add a column to the user table - it just hasn't been done.
rather than searching all players games ,howabout creating a couple of fields and have total query average opponent in games to date and number of games played ,lock that figure, when next game finishes use static figures and new game value to calculate current average
you could update static figures weekly or monthly , it would save time instead of searching all games in DB for this value it would only be looking at a month max.
it's not a matter of not knowing how to do it, it's a matter of finding the time :)