Difference between flg_sb and position=9

[beninu]

I heve been looking many places for this but I have a really hard time finding a definitive answer to the difference between the two following stats:

So can anyone tell me - what is the difference between these two stats:

Code: Select all

tourney_hand_player_statistics.position = 9

and

Code: Select all

lookup_positions.flg_sb

I do understand that the first one is reporting a position, that could be anything and that it's an expression that only evaluates to true if the value returns 9, whereas the other specifically asks if the player is in that single specific position. But as far as I can tell the two expressions will always evaluate to the same result (either trie or false). Or am I wrong? Can anyone tell me of a situaition where these two expressions would compute with different results (i.e. one evaluates to true and the other to false in the same given situation)?

I may understand an explanation to be that one is seen from the hand perspective whereas the other is seen from the player perspective, as the one returns the position from which a given hand was played, whereas the other deals with the position of a player in a given hand, but is that even true? And still will the result of these two expressions ever differ in any way? Or is this just two ways to obtain the exact same result in the end?

Any clarification would be greatly appreciated!

Thanks in advance.

Kind regards

Beninu Andersen
DENMARK

[Flag_Hippo]

The PokerTracker database structure has changed/expanded over time and there are many database tables so there are instances where different bits of code do the same thing. If you are building custom statistics then I'd recommend using tourney_hand_player_statistics.position = 9 because if you use lookup_positions.flg_sb then that column won't be able to use the database cache.

[beninu]

The PokerTracker database structure has changed/expanded over time and there are many differetn database tables so there are instances where different bits of code do the same thing. If you are building custom statistics then I'd recommend using tourney_hand_player_statistics.position = 9 because if you use lookup_positions.flg_sb then that column won't be able to use the database cache.

Thank you for a swift reply! The caching information is truly valuable information - thanx alot!

[kielon89]

im trying to modify my HUD and I noticed that many of statistics still use "lookup_positions" in their definitions. Is it a good idea to replace all these references with "tourney_hand_player_statistics.position"? Then all stats in my HUD will use cache and as a result I get increase of performance because HUD wont communicate from database so often - am I right?