Filter hands by VPIP (or any other villain stat)

[bekonja]

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?

[Flag_Hippo]

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.

[montag]

Couldn't you make the answer public? I got a similar error message...

[4StarGen]

^ this is not how support is suppose to work. Open yourself up a ticket requesting to be linked with this issue.

[bekonja]

Made a ticket already, got some feedback, yet no answer. Ill make a post in this topic if problem will be resolved.

[montag]

The "open a ticket" answer usually is a way of calming down the forums without solving anything.

[bekonja]

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.

[BillGatesIII]

This thread has a workaround.
https://www.pokertracker.com/forums/viewtopic.php?f=61&t=58819&start=10#p289938

[4StarGen]

^ 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?

[BillGatesIII]

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