Facing a pocket pair

General discussion of PokerTracker 3.

Moderator: Moderators

Re: Facing a pocket pair

Postby WhiteRider » Fri Feb 14, 2014 8:33 am

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.
WhiteRider
Moderator
 
Posts: 53961
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Facing a pocket pair

Postby kraada » Mon Feb 17, 2014 3:58 pm

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.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Facing a pocket pair

Postby andrewy01 » Wed Feb 19, 2014 3:49 am

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.
andrewy01
 
Posts: 6
Joined: Tue Jan 03, 2012 4:29 am

Re: Facing a pocket pair

Postby kraada » Wed Feb 19, 2014 8:41 am

How large is your database (in Database Management)? This is for PT4, right?
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Facing a pocket pair

Postby andrewy01 » Wed Feb 19, 2014 10:08 am

Yes pt4
Size = 4700 mb
andrewy01
 
Posts: 6
Joined: Tue Jan 03, 2012 4:29 am

Re: Facing a pocket pair

Postby kraada » Wed Feb 19, 2014 11:51 am

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.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Facing a pocket pair

Postby andrewy01 » Wed Feb 19, 2014 5:25 pm

Seems like that should work but it still hangs after 20 min
andrewy01
 
Posts: 6
Joined: Tue Jan 03, 2012 4:29 am

Re: Facing a pocket pair

Postby kraada » Wed Feb 19, 2014 5:42 pm

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.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Facing a pocket pair

Postby BillGatesIII » Wed Feb 19, 2014 6:08 pm

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)
BillGatesIII
 
Posts: 740
Joined: Fri Dec 16, 2011 6:50 pm

Re: Facing a pocket pair

Postby andrewy01 » Wed Feb 19, 2014 6:40 pm

Still hangs - 10 minutes with no completion
andrewy01
 
Posts: 6
Joined: Tue Jan 03, 2012 4:29 am

PreviousNext

Return to General [Read Only]

Who is online

Users browsing this forum: Amazonbot and 16 guests

cron
highfalutin