Hi, for the last 4 days or so our ratings have not changed at all. There are only 2 of us who play each other so we have an idea of how many wins/losses we each have and we know the ratings should have changed. They haven't. Is there a glitch or is there a way that we can fix it ourselves? We always enable ratings when we create a game
thanks for any help
The ratings have not been updated for some days (4 sounds right, maybe 1 more) because the calculation took a big toll on the database server, which was one cause of the lag that started 1-2 weeks ago. Since the lag seems to have been greatly reduced/mostly eliminated, Stef will try to add it back, hopefully even with less effect on the database.
thanks for the explanation - appreciated :-)
I've worked a bunch on DBs. Do you know exactly what the issue is?
You might want to consider:
1) That maybe the updates are locking rows?
2) Is it maybe in a long running transaction that then blocks all rows within that transaction?
3) If possible running the updates against a different DB? That is storing the user ratings in a different DB.