Development discussion. Logged to https://ddnet.tw/irclogs/ Connected with DDNet's IRC channel, Matrix room and GitHub repositories — IRC: #ddnet on Quakenet | Matrix: #ddnet-developer:matrix.org GitHub: https://github.com/ddnet
Between 2021-03-11 00:00:00Z and 2021-03-12 00:00:00Z
if i knew the name i would straight up told you but i forgot it @heinrich5991 the folks from the minecraft paper community use it its some smaller self made thing but it aims to be fully featured
Didn't know this existed - very useful to see the performance numbers. Alright so the load on the server isn't bad at all. Would then only help with latency.
deen
If you add another caching layer, how will you know when the data is out of date? This is tradionally the job of a database
You could have a distributed memcache, but very much an overkill here and doubt it is possible with the given infrastructure. Few options:
A flattened storage/table to track the more heavy queries. This will solve for consistency across servers.
A cache per server where you don't solve for real-time consistency:
Unlikely for certain queries to change minute-by-minute
Unlikely that two servers will be on the same map impacting the same query
Refresh cache after X period or other
Move database behind an API with external servers making queries to it.
That said, none of the above options are worth it seeing that a relatively small server is handling the load fine.
The show ShowTop can sometimes take a second or two. Noticed this when going around different servers to test it. My main concern was that the underlying database was taking strain - hence the suggestion.
It isn't too slow so an index or change in the query could definitely help
Yeah, can see how it is received with the update. It isn't doing two calls when the region has a high score so for the bigger servers the command will function the same
A usual test would be to assess the feeling of it among the Chinese community. They have a significant representation, relatively new community with low rankings and tend to be patriotic / care more about their peers.
The show ShowTop can sometimes take a second or two. Noticed this when going around different servers to test it. My main concern was that the underlying database was taking strain - hence the suggestion.
It isn't too slow so an index or change in the query could definitely help
@Zodiac could always do local rank to where the map was finished irrespective of server, then display unranked if on a different server like the RUS example above.
Just a small suggestion but dont want to complicate things.
@Zodiac could always do local rank to where the map was finished irrespective of server, then display unranked if on a different server like the RUS example above.
Just a small suggestion but dont want to complicate things.
@noby check where you're generating the server info, and see what you're doing after the map name and before the map size. or send me hte relevant code somewhere and I'll fix it