Export Hero hands doesnt work... (HEM2 7725)

[hemorider]

hello folks,

i want to export all hero hands, but it doesnt do a thing. it prompts 'pls be patient' but after hours it didnt happen anything. i cant end the program either as 'background process is running'. i finally killed it via task manager...

i tried different screennames, aliases etc but always the same thing....

please help me out, itd be a big disappointment if i couldnt get this to work. (the archive folder is no option, the hands in question are much much older).

im using a win7 desktoip pc with avira running, never had any problems up until now...
i recently changed my DB location to another HD (used the how-to you guys provided, worked out just fine), dont think that has anything to do with it as others had the same issue...

thank you very much for your assistance, with kind regards
hemorider

[udbrky]

Make sure that the disk to which you are saving the hands has enough space.

Please see this FAQ to move your DB to another drive.

http://hm2faq.holdemmanager.com/questions/1172/Move+Database+to+Another+Hard+Drive+or+Partition

Out of HM1, HM2, PT3, HM2 has by far the smallest DB's.

Some SSD's now use compression automatically. The Truth About SSDs and Compression (http://rscott.org/ssd/SSDs_and_compression.htm)

You can also use NTFS compression on the DB folder in roaming and the postgres\data\base folder to make it smaller:

Best practices for NTFS compression in Windows (http://support.microsoft.com/kb/251186)

You can put your postgres data folder and the HM2 database parent folder on a different drive.

In HM1 there are a lot of tables that deal with a specific hand played by a specific player. In HM2 we don't have these tables, instead, for player related hand data, we use a flat file approach. Each player has his own folder and each file represents a single day. Each line within the file is a tokenized version of a single hand with incredible amounts of detail. Your overall HM2 spaced used (DB + Files) is about 2/3 of HM1 and we store probably 2-3 times as much info plus it can be accessed many, many times faster and allows us to do some things that wouldn't be possible otherwise, many of which are yet to come. If you don't want the space in your Roaming folder due to C: file space or something like that, we do give you the option of storing this data anywhere

General rule is 1 million hands = 10 GB.

In reality it's: 1 million hands
HM1: 6.8 GB
HM2: 4.3 GB
PT4: 13.6 GB

So with a 10 million hand database you need as SSD of at least 60 GB (Windows) + 100 GB = 160 GB.
We use 1 million = 10 GB (instead of 6.8) because when you want to perform a vacuum/analyse or backup/restore a database it will require a LOT of disk space to perform such a task.

You can also run tree size free to locate wastes of space:

TreeSize Free - Quickly Scan Directory Sizes and Find Space Hogs (http://www.jam-software.com/treesize_free/)

Please see this guide to optimize your SSD:

Can You Get More Space Or Speed From Your SSD? : Optimizing Precious Solid-State Storage (http://www.tomshardware.com/reviews/ssd-performance-tweak,2911.html)


If you continue to have problems, please reproduce the problem, describe exactly what you were doing, and attach your log.txt file -

http://hm2faq.holdemmanager.com/questions/1921/How+Do+I+Send+a+Log+File+to+Holdem+Manager+Support %3F

[udbrky]

Make sure that the disk to which you are saving the hands has enough space.

Please see this FAQ to move your DB to another drive.

http://hm2faq.holdemmanager.com/questions/1172/Move+Database+to+Another+Hard+Drive+or+Partition

Out of HM1, HM2, PT3, HM2 has by far the smallest DB's.

Some SSD's now use compression automatically. The Truth About SSDs and Compression (http://rscott.org/ssd/SSDs_and_compression.htm)

You can also use NTFS compression on the DB folder in roaming and the postgres\data\base folder to make it smaller:

Best practices for NTFS compression in Windows (http://support.microsoft.com/kb/251186)

You can put your postgres data folder and the HM2 database parent folder on a different drive.

In HM1 there are a lot of tables that deal with a specific hand played by a specific player. In HM2 we don't have these tables, instead, for player related hand data, we use a flat file approach. Each player has his own folder and each file represents a single day. Each line within the file is a tokenized version of a single hand with incredible amounts of detail. Your overall HM2 spaced used (DB + Files) is about 2/3 of HM1 and we store probably 2-3 times as much info plus it can be accessed many, many times faster and allows us to do some things that wouldn't be possible otherwise, many of which are yet to come. If you don't want the space in your Roaming folder due to C: file space or something like that, we do give you the option of storing this data anywhere

General rule is 1 million hands = 10 GB.

In reality it's: 1 million hands
HM1: 6.8 GB
HM2: 4.3 GB
PT4: 13.6 GB

So with a 10 million hand database you need as SSD of at least 60 GB (Windows) + 100 GB = 160 GB.
We use 1 million = 10 GB (instead of 6.8) because when you want to perform a vacuum/analyse or backup/restore a database it will require a LOT of disk space to perform such a task.

You can also run tree size free to locate wastes of space:

TreeSize Free - Quickly Scan Directory Sizes and Find Space Hogs (http://www.jam-software.com/treesize_free/)

Please see this guide to optimize your SSD:

Can You Get More Space Or Speed From Your SSD? : Optimizing Precious Solid-State Storage (http://www.tomshardware.com/reviews/ssd-performance-tweak,2911.html)


If you continue to have problems, please reproduce the problem, describe exactly what you were doing, and attach your log.txt file -

http://hm2faq.holdemmanager.com/questions/1921/How+Do+I+Send+a+Log+File+to+Holdem+Manager+Support %3F

[hemorider]

hello mr udbrky,
thank you for your quick response first!

i definitely have enough space on my D:\ partition. its the same physical HD, no external or whatever and everything else (HUD, reports etc..) works out just fine, so this cant be the problem...

the information about the size u provided is interesting but unfortunately of limited use for my issue...

thing is:
i have loads of mined hands every month, and i have my own hands, my careers history so to say...
the latter i dont have the original HHs anymore as some of em are ancient.

my task is to keep the DB clean and reasonably large, while not losing my old hands. so i want to export my own and then purge the old mined hands or start a new DB every few months, u know? that is my problem..

if you could help me fix that 'hero export' issue, i would be very thankful..
thanks alot, greets
hemorider

[Patvs]

On which site did you play (most) of your hero games?

If you played them on PokerStars, PartyPoker or Full Tilt, you could email their support and request the handhistories for every hand you've ever played... since ideally you should always save your original handhistories (by backing up the archive folder).


To actually export the hero hands from HM2: we have a bugticket on this HM-6508.
The ticket is about the fact "Exporting by Hero Only is significantly slower than Export All".

So what you should try again: export by hero only... then let it run overnight. Ignore any 'not responding' message.
As long as postgres.exe or holdemmanager.exe in TaskManager is showing some activity it's likely still exporting the hands.
Alternatively, just export ALL HANDS... if that works, you can easily reimport your hands into a new database, and then DELETE the non-hero hands.

[hemorider]

hello pat,
thanks for your answer and sorry for the lateness of mine..

the trick with the purging except hero hands is as simple as it is good.
it took forever to export/import and then purge, but as i said, my DB is quite large..

i seem to have fucked up something with the alias-settings though, because in the end, my final export was just 2 files with pretty random stuff...

i think i give up for the time being, but i really appreciate your help.
thank you and greetings,
hemorider