Ranking on gametable

bestevaer · Sat Apr 17, 2021 3:34 pm

Now the gametable shows: average score / final score / season games.

Would like to also see the ranking.

Sat Apr 17, 2021 3:40 pm

Game-Table is not yet finished. It's a hell of calculating ranking position in real-time for the database ... I am still thinking of the best solution.

... just be patient

bestevaer · Sat Apr 17, 2021 3:44 pm

OK, will be patient. What about this one: viewtopic.php?f=4&t=109&sid=268e10c81c5 ... 24ddc1713c

Sat Apr 17, 2021 3:46 pm

bestevaer wrote: ↑Sat Apr 17, 2021 3:44 pm OK, will be patient. What about this one: viewtopic.php?f=4&t=109&sid=268e10c81c5 ... 24ddc1713c

BarbaB · Mon Apr 19, 2021 3:52 pm

sp0ck wrote: ↑Sat Apr 17, 2021 3:40 pm Game-Table is not yet finished. It's a hell of calculating ranking position in real-time for the database ... I am still thinking of the best solution.

... just be patient

I'd suggest to make a stats cache (table with record per player) and update it after each game is finished (ranking games). Player record may contain other stats as well.
When player is not found in the table, return table size +1.

Mon Apr 19, 2021 9:16 pm

BarbaB wrote: ↑Mon Apr 19, 2021 3:52 pm
sp0ck wrote: ↑Sat Apr 17, 2021 3:40 pm Game-Table is not yet finished. It's a hell of calculating ranking position in real-time for the database ... I am still thinking of the best solution.

... just be patient
I'd suggest to make a stats cache (table with record per player) and update it after each game is finished (ranking games). Player record may contain other stats as well.
When player is not found in the table, return table size +1.

Nah - the amount of data can be handled in real-time.