[fatal Error]Try to Purge HH

[vingte]

Hi,

I currently get some big freeze on my computer while using HEM (about every 10-15 minutes). I really think it's related to the size of the database.

So I took some time and found this post:
Top 10: HEM performance increase tips

I did most of the things, but I also want to delete some hand histories in the database itself while still keeping the stats. When I hit the button, I get a fatal error (see attachment) I use the release 1.11.02, but it was already the case with the release I used like 1 and 1 half year ago. --> I think it's related to the language of java in my computer (it's french).

I really would like to purge some hh in my database, and I've got strong SQL knowledges, so I can do by myself .

If you can just tell me in which tables can records be deleted while still keeping the stats accurate (I mean the HUD + my results + Ev$), it will be perfect. I already have an idea, but I will be more confident if you can confirm it.

Here are my top 15 tables in number of records.

playervsplayer 2,093,780
playerhandscashkeycolumns 1,879,150
playerhandscashmisc 1,879,150
postflopactions_month 1,264,020
playerhandstourneykeycolumns 897,011
playerhandstourneymisc 897,011
playerhandsflop 694,645
handhistories 534,083
pokerhands 534,083
pokerhands_hero 533,973
playerhandsturn 427,915
playerhandscashkeycolumns_hero 391,613
playerhandscashmisc_hero 391,613
playervsplayer_hero 366,483
playerhandsriver 312,932

Thanks
Yann

[morny]

There is a bug with the purge in 1.11.02, simplest thing is to downgrade to an older version and purge the hands http://forums.holdemmanager.com/rele...l-release.html