First off, I’m just glad this issue is being addressed at all. I welcome any changes related to it.
I think the ping ranges you mention is a good idea. Only concern would be that they still get ordered by ping under the hood. Currently whoever has the lowest ping gets put at the top of the list by default. As long as the new system somewhat randomizes the servers inside the same ping bucket, then this makes sense.
In other words, all “low” ping servers are above “medium,” but the servers inside “low” are randomized rather than ordered by ping.
Regardless, cheers Lama. Thank you for researching this. I’ve been a huge and very vocal opponent of query caching and we started to have to move our own servers just to stay competitive. Hopefully that won’t be necessary moving forward with this. Much love.