3Bet Preflop vs Hero

[4StarGen]

ok but why in a single player report the query is super fast?

SELECT (sum((case when(cash_hand_player_statistics.flg_p_3bet AND EXISTS (SELECT 1 FROM cash_hand_player_statistics hero WHERE hero.id_hand = cash_hand_player_statistics.id_hand AND hero.flg_hero AND hero.flg_p_first_raise) ) then 1 else 0 end))) as "cnt_p_3bet_vs_hero", (sum((case when(cash_hand_player_statistics.flg_p_3bet_opp AND EXISTS (SELECT 1 FROM cash_hand_player_statistics hero WHERE hero.id_hand = cash_hand_player_statistics.id_hand AND hero.flg_hero AND hero.flg_p_first_raise) ) then 1 else 0 end))) as "cnt_p_3bet_opp_vs_hero" FROM cash_hand_player_statistics WHERE (cash_hand_player_statistics.id_player = (SELECT id_player FROM player WHERE player_name_search=E'j' AND id_site='100')) AND ((cash_hand_player_statistics.id_gametype = 1))
2014/12/10 20:08:07.525 [02564]: [00001650][Query] Query execution time: 2564.24828419 ms

[BillGatesIII]

Is this last query for the player you have played 42k hands with?

[4StarGen]

nope, but I run it below with the corresponding results...

Code: Select all

 Query execution time: 30889.66497966 ms[/b]

ah, you have a PM

[kraada]

I'm guessing it's because you have three aliases attached to the player in the original query that's going to make things take longer.

[4StarGen]

^
I'm not following you, 3 aliases?

[kraada]

Oh never mind I see now you just were doing it for all players in the hand. The single letter redacted player names confused me

[potamito]

Trying to build a BvB Resteal shove vs HERO stat and even tho i got a valid statement i got a message saying this column cannot be cached, this is what i got...

cnt_resteal_shove_att_bb_vs_hero

Code: Select all

sum(if[tourney_hand_player_statistics.flg_p_3bet AND tourney_hand_player_statistics.enum_allin SIMILAR TO '(p|P)' AND lookup_actions_p.action = 'R' and tourney_hand_player_statistics.flg_blind_def_opp and exists
    (select 1  from tourney_hand_player_statistics hero  where hero.id_hand = tourney_hand_player_statistics.id_hand   and hero.flg_hero  and hero.position = 9), 1, 0])


Same for the opp expresion...

cnt_resteal_opp_shove_att_bb_vs_hero

Code: Select all

sum(if[tourney_hand_player_statistics.flg_p_3bet AND tourney_hand_player_statistics.enum_allin SIMILAR TO '(p|P)' AND lookup_actions_p.action = 'R' and tourney_hand_player_statistics.flg_blind_def_opp and exists
    (select 1  from tourney_hand_player_statistics hero  where hero.id_hand = tourney_hand_player_statistics.id_hand  and hero.flg_hero  and hero.position = 9), 1, 0])

[4StarGen]

Subqueries cannot be cached

[potamito]

And the fact it cannot be cached means exactly what? slower performance? cant create the stat?

[4StarGen]

slower performance