PDA

View Full Version : [fatal Error]Try to Purge HH



vingte
06-23-2010, 06:00 PM
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:
http://forums.holdemmanager.com/manager-general/11194-top-10-hem-performance-increase-tips.html

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. :D

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
06-24-2010, 05:55 AM
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/releases/30576-1-11-02-official-release.html