Ranking on gametable

General PokerTH Issues
Post Reply
User avatar
bestevaer
Posts: 37
Joined: Sat Apr 03, 2021 5:30 pm
Location: Netherlands

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

Would like to also see the ranking.
sp0ck
Posts: 71
Joined: Mon Mar 15, 2021 12:54 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 ;-)
User avatar
bestevaer
Posts: 37
Joined: Sat Apr 03, 2021 5:30 pm
Location: Netherlands

OK, will be patient. What about this one: viewtopic.php?f=4&t=109&sid=268e10c81c5 ... 24ddc1713c
sp0ck
Posts: 71
Joined: Mon Mar 15, 2021 12:54 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
User avatar
BarbaB
Posts: 5
Joined: Thu Apr 01, 2021 6:00 pm
Location: Ljubljana

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.
Sailor and poker addict :evil: :evil:
sp0ck
Posts: 71
Joined: Mon Mar 15, 2021 12:54 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.
Post Reply