Ranking on gametable

General PokerTH Issues
Post Reply
User avatar
bestevaer
Posts: 54
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.
User avatar
sp0ck
Posts: 89
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: 54
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
User avatar
sp0ck
Posts: 89
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: 6
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:
User avatar
sp0ck
Posts: 89
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.
User avatar
bestevaer
Posts: 54
Joined: Sat Apr 03, 2021 5:30 pm
Location: Netherlands

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 ;-)
Any news about if and/or when the ranking position will be shown on gametable? It was so before the fire/crash, would like to see it again.
User avatar
sp0ck
Posts: 89
Joined: Mon Mar 15, 2021 12:54 pm

bestevaer wrote: Wed Jun 02, 2021 3:40 pm It was so before the fire/crash
There is no need to remind at each feature request that it was on the site before the crash.

There are no news - I'm busy earning real money these days. Please stay patient. 8-)
Post Reply