question about "general" stats

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

Re: question about "general" stats

Postby Messenjupp » Tue Jul 19, 2011 7:33 am

1. Is there kind of a diagnostic tool that tells me that DBs are too big or that tuning up some things might increase performance? I'm pretty sure that my Intel Core 2 Duo CP E8500 3.16GHz with 4 GB Ram and a 32 Bit System is not the problem or at least not a real problem. I'm running windows vista home premium as an operating system. I noticed lately that after moving to party that my CPU usage is pretty high so i was wondering what the problem might be.

2. What about the stat I created...does this not work or are there situations missing? Just wondering.

3. Is there any point in exporting old own HHs (a year or older) and deleting the HHs so that those DBs are not even in the system anymore although I dont use them or does this not have any influence at all as long as I dont use them?

4. I just saw the adjust limits button when clicking on database management...never noticed that before...can you please tell me whats that for or give me the link to where I can read about it..thx.
Messenjupp
 
Posts: 204
Joined: Wed Oct 08, 2008 6:54 am

Re: question about "general" stats

Postby kraada » Tue Jul 19, 2011 9:13 am

(1) That might be more of a Party issue - you should be able to handle at least a few million hands on that system in any given database.

(2) It would give you numbers but they wouldn't really be the numbers you'd want. If you check/fold once out of position, then cbet once in position your stat would have you at 50% - because you saw two flops.

(3) If you're experiencing severe slowdowns you could do this. Honestly I doubt it's worth the effort. And personally I like having my historical data.

(4) That's for changing the limit on a session - say from $1NL to $1NL (6 Max) or vice versa.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: question about "general" stats

Postby Messenjupp » Wed Jul 20, 2011 12:38 pm

By the way...my HUD on party and also before on non rush FTP only shows after the first hand...this shouldnt be, right? What do I have to do to get this fixed?
Messenjupp
 
Posts: 204
Joined: Wed Oct 08, 2008 6:54 am

Re: question about "general" stats

Postby kraada » Wed Jul 20, 2011 1:00 pm

That is expected behavior - until we've imported a hand we don't know what stats to display where.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: question about "general" stats

Postby Messenjupp » Wed Jul 20, 2011 8:23 pm

kraada wrote:That is expected behavior - until we've imported a hand we don't know what stats to display where.


Why not using the same method as you did for rush? Just curious.
Messenjupp
 
Posts: 204
Joined: Wed Oct 08, 2008 6:54 am

Re: question about "general" stats

Postby WhiteRider » Thu Jul 21, 2011 3:41 am

Adding that kind of functionality is pretty complex as every site is different, and would be a significant amount of work to implement and maintain it across all sites - it may not even be possible for all sites.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: question about "general" stats

Postby Messenjupp » Thu Jul 21, 2011 9:54 pm

Having some problem....for some reason my HUD does not show the number of hands it is supposed to be....

I'm using two DB...one for observed hands and one for played hands. HUD is configured that it shows both DB and player ranges are set min5 and max6, min3 and max4 and min2 and max3 in that order...so 5/6 comes first/on top. refresh rate is default and it shows only stats for the current cash game limit.

However one player the HUD only showed 120 hands whereas in boht DB I had 430 hands on him. and for one guy it was even more sincere..it only showed 100 while I had 2k on him. I checked the observed hands DB later and it seems that it pretty much misses all the hands from the 2nd DB (observed hands). So whats my line here.....is there a logfile that I can send you where you can see why it does not show all the hands?

I'm also using Tablescan Turbo and on there it works fine...it shows the hands of both DBs. But I guess that does not matter but wanted to mention it just in case.
Messenjupp
 
Posts: 204
Joined: Wed Oct 08, 2008 6:54 am

Re: question about "general" stats

Postby WhiteRider » Fri Jul 22, 2011 3:32 am

Are you using the Player Icon in the HUD?
Try removing that from your layout completely as there are known issues with that when using multiple databases.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: question about "general" stats

Postby Messenjupp » Fri Jul 22, 2011 7:40 am

WhiteRider wrote:Are you using the Player Icon in the HUD?
Try removing that from your layout completely as there are known issues with that when using multiple databases.


I just checked cause I wasnt sure but its not used in the HUD/popup I used the last days. I can send the profile to you if you wanna check for something else that might cause a problem. I just checked replayer and those numbers seem to be way more accurate.
Messenjupp
 
Posts: 204
Joined: Wed Oct 08, 2008 6:54 am

Re: question about "general" stats

Postby kraada » Fri Jul 22, 2011 8:12 am

Please do - send it via our support system.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

PreviousNext

Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests