Facing a pocket pair

[WhiteRider]

It's not working for me either, but I'm not sure why - hopefully Kraada will be able to tell us when he gets back after the weekend.

[kraada]

That was PT3 code not PT4 code so it won't work for PT4.

To alter it, change "holdem_hand_player_statistics" to "cash_hand_player_statistics" in all cases.

[andrewy01]

When I run the query it validates which is great, however the report runs and never gets completed even if I run it for 1 day and wait 20 minutes.

[kraada]

How large is your database (in Database Management)? This is for PT4, right?

[andrewy01]

Yes pt4
Size = 4700 mb

[kraada]

That shouldn't take that long. This seems to work:

cash_hand_player_statistics.id_hand in (SELECT chps.id_hand FROM cash_hand_player_statistics chps WHERE chps.id_holecard in (1, 26, 49, 70, 89, 106, 121, 134, 145, 154, 161, 169) and not(chps.flg_hero) GROUP BY chps.id_hand, chps.id_player)

This filters to all hands where someone who wasn't you had a pocket pair. You can use simple filters then to filter for your own pocket pair hands. It returns data for me in a few seconds, you might need to wait up to a minute but it shouldn't take much more than that.

[andrewy01]

Seems like that should work but it still hangs after 20 min

[kraada]

And you're doing this in a report in My Reports -> New Player Report? It definitely works for me and takes ~4 seconds to complete (on a database roughly half as big as yours). If not, try it there. If so, please restart PT4 using the logging enabled link on your Start Menu, reproduce this problem and then report it via our support system with the log file - that will help us figure out what is going on here and get it fixed for you. You can find that file by clicking File --> Show User Data Folder in the main PT4 window - the file we need is the text file called PokerTracker4 that is in that folder. Tell them to send the log to me and I'll look at what's going on in your query.

[BillGatesIII]

Try this.

Code: Select all

exists (
  select 1
  from cash_hand_player_statistics chps
  where chps.id_holecard in (1, 26, 49, 70, 89, 106, 121, 134, 145, 154, 161, 169)
  and not(chps.flg_hero)
  and chps.id_hand = cash_hand_player_statistics.id_hand)

[andrewy01]

Still hangs - 10 minutes with no completion