Filter hands by VPIP (or any other villain stat)

Let us know what features not currently in the PT4 should be added.

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Re: Filter hands by VPIP (or any other villain stat)

Postby bekonja » Wed Dec 21, 2016 10:09 am

Applying filter to 'Position' report sends db into infinite load.
Applying filter to 'Hands' report returns following error: http://puu.sh/sWzmP/cbc4b57699.png
Re-creating db doesnt help. Any ideas pls?
bekonja
 
Posts: 23
Joined: Mon Dec 16, 2013 7:09 pm
Location: Russia

Re: Filter hands by VPIP (or any other villain stat)

Postby Flag_Hippo » Wed Dec 21, 2016 3:18 pm

Please open a Support Ticket with a link to this thread and report your problem so that we can check your log file and see what is going on.
Flag_Hippo
Moderator
 
Posts: 14441
Joined: Tue Jan 31, 2012 7:50 am

Re: Filter hands by VPIP (or any other villain stat)

Postby montag » Thu Dec 22, 2016 2:52 pm

Couldn't you make the answer public? I got a similar error message...
montag
 
Posts: 26
Joined: Thu Oct 03, 2013 6:00 am

Re: Filter hands by VPIP (or any other villain stat)

Postby 4StarGen » Thu Dec 22, 2016 6:22 pm

^ this is not how support is suppose to work. Open yourself up a ticket requesting to be linked with this issue.
4StarGen
 
Posts: 928
Joined: Sat Mar 08, 2014 6:58 am

Re: Filter hands by VPIP (or any other villain stat)

Postby bekonja » Fri Dec 23, 2016 2:16 pm

Made a ticket already, got some feedback, yet no answer. Ill make a post in this topic if problem will be resolved.
bekonja
 
Posts: 23
Joined: Mon Dec 16, 2013 7:09 pm
Location: Russia

Re: Filter hands by VPIP (or any other villain stat)

Postby montag » Wed Jan 04, 2017 4:25 pm

The "open a ticket" answer usually is a way of calming down the forums without solving anything.
montag
 
Posts: 26
Joined: Thu Oct 03, 2013 6:00 am

Re: Filter hands by VPIP (or any other villain stat)

Postby bekonja » Wed Jan 11, 2017 11:43 pm

Recent update on the problem:
1. Filter is correct by its syntax
2. Filter is incorrect by its logic - for 6max it displays every hand with some opponent on the table having specified vpip. Idk why it wasn't pointed out in all previous topics.
3. Filter is unusable on adequate hardware/database setups. With my ssd drive it takes 1-2m to load on 100 hands database, more than 1 hour to load on 4k hands and i guess some ridiculous time on larger scales. Once again for all that years and topics no one pointed that out.
4. Filter is unusable on "Hands" type report and results some error. Nothing we can do here, hope its get fixed.
Obviously that filter should be somehow changed to meet its purpose - show only hands that was played against certain type of opponent. Maybe some of moderators who is proficient in SQL can fix that, me myself have no time for learning it atm.
P.S. - i think for reducing load time filter should be like:
Code: Select all
IF (player1_name=HERO AND player1_saw_flop=TRUE) THEN
 {
     IF (player2_vpip={M-N} AND player2_saw_flop=TRUE) THEN
          display_hands
 }

The idea is from all of hands chose only ones where HERO saw flop, and then from that subset distinguish ones where some of opponents has desired range of vpip and also saw flop.
bekonja
 
Posts: 23
Joined: Mon Dec 16, 2013 7:09 pm
Location: Russia

Re: Filter hands by VPIP (or any other villain stat)

Postby BillGatesIII » Thu Jan 12, 2017 2:27 pm

BillGatesIII
 
Posts: 740
Joined: Fri Dec 16, 2011 6:50 pm

Re: Filter hands by VPIP (or any other villain stat)

Postby 4StarGen » Thu Jan 12, 2017 4:14 pm

^ it would be plain simple if we can use a view where players' stats are already calculated. Then we could do an easy join to achieve what we are looking for. Since you skilled I'm sure you already thought about it and if you didn't mention probably it is unfeaseble, may I ask you why?
4StarGen
 
Posts: 928
Joined: Sat Mar 08, 2014 6:58 am

Re: Filter hands by VPIP (or any other villain stat)

Postby BillGatesIII » Sat Jan 14, 2017 9:23 am

    Why would you want to use a view if the stats are already calculated in the cache tables?

    There is another forum user, athrac, who uses his own tables, that should work the same as views.

    https://www.pokertracker.com/forums/viewtopic.php?f=61&t=91983
    BillGatesIII
     
    Posts: 740
    Joined: Fri Dec 16, 2011 6:50 pm

    PreviousNext

    Return to PT4 Feature Requests

    Who is online

    Users browsing this forum: No registered users and 11 guests

    cron
    highfalutin