Ranking on gametable

General PokerTH Issues
Post Reply
User avatar
sp0ck
Posts: 236
Joined: Mon Mar 15, 2021 12:54 pm
Location: Flensburg
Been thanked: 12 times

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
sp0ck
Posts: 236
Joined: Mon Mar 15, 2021 12:54 pm
Location: Flensburg
Been thanked: 12 times

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: 22
Joined: Thu Apr 01, 2021 6:00 pm
Location: Ljubljana
Been thanked: 4 times

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.
First and foremost I'm a sailor :evil: :evil:
User avatar
sp0ck
Posts: 236
Joined: Mon Mar 15, 2021 12:54 pm
Location: Flensburg
Been thanked: 12 times

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
sp0ck
Posts: 236
Joined: Mon Mar 15, 2021 12:54 pm
Location: Flensburg
Been thanked: 12 times

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