[teddyFBI]

[ QUOTE ]
Thanks Teddy, that makes a lot of sense.

I think I'll add an option to SS (which will be used in PTAgg), to query the players only based on # of players (using my defaults) and limit vs. no-limit (so regardless of stakes). This will be the default option. I'll add another option to just do that game-type/stakes. And finally an option to pull from all game-types/stakes.

I don't want to change the # of players queried if I can help it. Its some work, and doesn't have much payoff.

I think that should get SS 98% there.

-Ben

[/ QUOTE ]

All of that sounds reasonable to me, and should look good.
Rigid 5-6 and 8-10 filters seem reasonable to me. It still won't fulfill your goal of having PTAGG/SS reflect EXACTLY what PAH pulls up (b/c people use all sorts of different PAH filters; mine, for example, are 4-6 and 7-10).

BUT, there is one issue left open, which shouldn't be too hard to solve, but you should be ready with a good solution.

So it's clear that when PTAGG comes across a table with 8-10 people sitting at it, it will say to itself:
"OK, let's look up each of these players' stats from hands that ALSO had 8-10 players being dealt cards."

Same goes for the 5-6 range. No problems there either.

But you'll have to decide how PTAGG/SS is going to treat 2-4 person games and 7-person games. It's fine to define SH as 5-6 and "full" as 8-10, but you have to decide what PTAGG is going to do when it sees a 7-person game going, for example. My personal recommendation? Treat it like a SH game...note that this DOESN'T mean you have to expand your filter from 5-6 to 5-7. All it means is that you have to be sure to tell PTAGG: "Hey, when you come across a 7-person game, I want you to display stats using your 5-6 filter.

Same goes for 2, 3, and 4-handed play. I definitley think you should keep the actual query that PTAGG does restricted to 5-to-6-person hands...why? b/c I think that 6-max games are sor of the norm, as discussed on internet forums, etc., and everyone is familiar with 6-max stats, and what a regular range is, etc. When I sit in a 4-handed game, for example, and I see an opponent's VPIP/PFR is 45/30 for 5-6-handed games, I know that means he's quite a bit LAGgy. But frankly, most people don't know what the "norm" is for a 3-handed or 4-handed game, because those aren't discussed as much as 6-handed games are. So it's just in line with keeping with the norm; hope the preceding made sense.

Cliff's notes is to just tell PTAGG to populate the query of a 7-handed game with stats from your 8-10 person filter, and to populate the query of 2-to-4 handed games with stats from your 5-6 filter.

Also, do you have any idea what is causing the VERSION_INFO error in PT that I referenced earlier that pops up when I try to open the ptagg database just like any other DB? That would make troubleshooting this whole thing a lot easier, b/c I could just go check what the ptagg DB has as the aggregated stats...and see if it's correctly matching up w/ the stats from the indiv DBs that went into creating it.