Regs player list hands

[BloMur]

I would like to separate hands played against regs. So far I was just typing and searching their nicknames one by one and tagging selected hands. Is there a faster way to do it ?

[Flag_Hippo]

If you are defining a "reg" as someone that has statistics within a specified range then you can build a custom filter for that - see this thread.

[BloMur]

I defining reg as someone I played most tournaments/hands against and I have a treshold number for this. Is it even possible to filter this ?

[Flag_Hippo]

Code: Select all

tourney_hand_player_statistics.id_hand in (select thps.id_hand from tourney_hand_player_statistics thps, tourney_cache tc where thps.id_player = tc.id_player group by thps.id_hand, thps.id_player having (sum(tc.cnt_hands) >= x and not thps.flg_hero))

where 'x' is the minimum number of hands you want.

[BloMur]

How would I also go about adding specific position on reg in question ? In 3-way (BTN, BB, SB) and HU spots ?

[Flag_Hippo]

Code: Select all

tourney_hand_player_statistics.id_hand in (select thps.id_hand from tourney_hand_player_statistics thps, tourney_cache tc where thps.id_player = tc.id_player group by thps.id_hand, thps.id_player having (sum(tc.cnt_hands) >= x and not thps.flg_hero and thps.position = y))

where 'y' is the player position.

[BloMur]

What about 3way and HU, How to differentiate if there was 2 or 3 player preflop.

[BloMur]

This method works, but the problem is database size. On big database I was unable to load hands, It is stuck on "loading..." for several hours. Is there a way to speed up this process ?

[Flag_Hippo]

How to differentiate if there was 2 or 3 player preflop.

Code: Select all

tourney_hand_summary.cnt_players = z and tourney_hand_player_statistics.id_hand in (select thps.id_hand from tourney_hand_player_statistics thps, tourney_cache tc where thps.id_player = tc.id_player group by thps.id_hand, thps.id_player having (sum(tc.cnt_hands) >= x and not thps.flg_hero and thps.position = y))

where 'z' is the number of players dealt into the hand.

This method works, but the problem is database size. On big database I was unable to load hands, It is stuck on "loading..." for several hours. Is there a way to speed up this process ?

Did you start using a built-in filter for the number of players? If you did then clear that and filter for everything you need inside the expression filter.

[BloMur]

I only used expression filter and still it is stuck in "loading...". I even deleted all the info about hand (like time, hole cards etc) and left only hand# and it did not helped.