Two Plus Two Publishing LLC Two Plus Two Publishing LLC
 

Go Back   Two Plus Two Poker Forums > Tournament Poker > Heads Up SNG

Notices

Heads Up SNG Discussion of heads up Sit & Go poker games. Sponsored by HUSNG.com, the leading heads up poker video site.

Reply
 
Thread Tools Display Modes
Old 09-04-2012, 04:53 AM   #76
adept
 
mrbambocha's Avatar
 
Join Date: Sep 2009
Posts: 987
Re: Script to analyze population tendency on HEM

Works only in hm1, but i think hem2 can take use of the gloabal alias better.
mrbambocha is offline   Reply With Quote
Old 09-04-2012, 05:05 AM   #77
grinder
 
tigerjack89's Avatar
 
Join Date: Jun 2010
Posts: 422
Re: Script to analyze population tendency on HEM

Quote:
Originally Posted by mrbambocha View Post
Works only in hm1, but i think hem2 can take use of the gloabal alias better.
Maybe genher can help you, he uses HEM2 and aliases without problems.
Questions: do you have different databases for HEM1/HEM2? Have you tried to dump/restore also HEM2 database?
Also, HEM2 databases are slightly different from HEM1, so the procedure to create an alias is different.
tigerjack89 is offline   Reply With Quote
Old 09-04-2012, 09:55 PM   #78
veteran
 
genher's Avatar
 
Join Date: May 2007
Location: Melbourne Australia
Posts: 2,538
Re: Script to analyze population tendency on HEM

Well I don't know
I have created a new database first, vacuum and reindexed it then just followed the process above to the letter and it works fine in HM2.

obv queries are a bit slow cause the data is huge but otherwise works fine
genher is offline   Reply With Quote
Old 12-28-2012, 10:15 AM   #79
adept
 
mrbambocha's Avatar
 
Join Date: Sep 2009
Posts: 987
Re: Script to analyze population tendency on HEM

Do you guys have any idea of how many players we can fit in into one alias?
mrbambocha is offline   Reply With Quote
Old 12-28-2012, 11:21 AM   #80
journeyman
 
Wisher's Avatar
 
Join Date: Jan 2012
Posts: 309
Re: Script to analyze population tendency on HEM

Quote:
Originally Posted by mrbambocha View Post
Do you guys have any idea of how many players we can fit in into one alias?
Have not found a limit yet.
Depends on what you consider as "can fit".
From a DB perspective - no worries to have tables with more than a million rows.
However, not sure how HEM1/2 will handle those.
Guessing it's a 32 bit piece of software it may have an issue with an array of more than 4,294,967,295 values.
In terms of it being useful - depends on your computer config a lot.
Wisher is offline   Reply With Quote
Old 12-28-2012, 01:02 PM   #81
adept
 
mrbambocha's Avatar
 
Join Date: Sep 2009
Posts: 987
Re: Script to analyze population tendency on HEM

Ok so it should be any problem with a DB between 10.000-50.000 players?

Im running the HEM2 pop alias on a 64-bit Core i5 2,4GHz laptop with 4GB ram, and a standard HDD with 13.000 villains but I just gets stuck and crashes every time I run it. Ive tested with 3000 players and that works fine.
mrbambocha is offline   Reply With Quote
Old 12-28-2012, 03:52 PM   #82
adept
 
mrbambocha's Avatar
 
Join Date: Sep 2009
Posts: 987
Re: Script to analyze population tendency on HEM

Questiong for later use when Ive figuared out what the problem for the above is.

What steps/codes do I need to take if I have four heros?
mrbambocha is offline   Reply With Quote
Old 03-03-2013, 11:14 PM   #83
old hand
 
Join Date: Jun 2012
Posts: 1,541
Re: Script to analyze population tendency on HEM

I have not tried any of this yet. Question, say I want to analyze my entire database's call in BB % when I open shove the button first hand in a 300 chip super turbo, is this possible? I don't need an explanation (for now) on how to do it if it is possible, I just want to know if its possible. I will read the thread over later. But could I analyze my entire DB this specifically? I am using HM1
p2 dog, p2 is offline   Reply With Quote
Old 03-05-2013, 03:39 PM   #84
veteran
 
genher's Avatar
 
Join Date: May 2007
Location: Melbourne Australia
Posts: 2,538
Re: Script to analyze population tendency on HEM

yes it is
genher is offline   Reply With Quote
Old 04-22-2013, 11:07 AM   #85
stranger
 
Join Date: Apr 2013
Posts: 4
Re: Script to analyze population tendency on HEM

Hi,

I use HM2 and did the process that tigerjack89 explains, but i can't make it to work.

I do all the things in pgAdmin. The problem is when i'm trying to open the Aliases on HM2.



When i try to select the Population, the HM2 stays a bit more slow, but do nothing.

This already happen to anyone?

Now, if i let it open a bit, after trying to change to Population and failed, this message appears:



Thanks (Sorry about my english)

Last edited by Hipo; 04-22-2013 at 11:15 AM.
Hipo is offline   Reply With Quote
Old 04-22-2013, 02:53 PM   #86
veteran
 
genher's Avatar
 
Join Date: May 2007
Location: Melbourne Australia
Posts: 2,538
Re: Script to analyze population tendency on HEM

Quote:
Originally Posted by Hipo View Post
Hi,

I use HM2 and did the process that tigerjack89 explains, but i can't make it to work.

I do all the things in pgAdmin. The problem is when i'm trying to open the Aliases on HM2.



When i try to select the Population, the HM2 stays a bit more slow, but do nothing.

This already happen to anyone?

Now, if i let it open a bit, after trying to change to Population and failed, this message appears:



Thanks (Sorry about my english)
how many players have you got in your DB?
genher is offline   Reply With Quote
Old 04-22-2013, 03:38 PM   #87
stranger
 
Join Date: Apr 2013
Posts: 4
Re: Script to analyze population tendency on HEM

Quote:
how many players have you got in your DB?
In that DB just about 1K. Can't understand why HM2 can't manage it.

Thanks
Hipo is offline   Reply With Quote
Old 04-22-2013, 04:19 PM   #88
veteran
 
genher's Avatar
 
Join Date: May 2007
Location: Melbourne Australia
Posts: 2,538
Re: Script to analyze population tendency on HEM

dunno...should be working.
genher is offline   Reply With Quote
Old 04-23-2013, 01:50 PM   #89
stranger
 
Join Date: Apr 2013
Posts: 4
Re: Script to analyze population tendency on HEM

Already fixed it. Just had to limit the results to less than 1K.

Could you tell me what tab do you use to analyse the results? The Reports, or Active Session?

Thank You
Hipo is offline   Reply With Quote
Old 04-23-2013, 04:12 PM   #90
veteran
 
genher's Avatar
 
Join Date: May 2007
Location: Melbourne Australia
Posts: 2,538
Re: Script to analyze population tendency on HEM

I limit mine to 14000 players and it works. You can use anything you like to look at the results. Any tab should work exactly as if there was only one player. be a bit patient thou because obv there is a lot of data to process it takes a few min for inquiries to work
genher is offline   Reply With Quote

Reply
      

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off



All times are GMT -4. The time now is 07:05 AM.


Powered by vBulletin®
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.6.0 ©2011, Crawlability, Inc.
Copyright © 2008-2010, Two Plus Two Interactive