PDA

View Full Version : How do I delete old hands to make my DB faster?



Naza114
02-25-2013, 08:55 PM
Hi,

I would like to know how do I delete olds hands to make my DB faster. I´ve tried the "purge hands" at Holdem Manager. Does the "purge hands" deletes the hands from the DB, or only from the HUD results?

Thanks

netsrak
02-26-2013, 07:57 AM
There are 2 methods of purging hands:
http://faq.holdemmanager.com/questions/197/Purge+Hands
http://faq.holdemmanager.com/questions/100/Purge+Hands+from+Database
The 2nd only deletes the stats, not the complete hands.

To speed up your database you should run a vacuum/full and a reindex via pgadmin: http://faq.holdemmanager.com/questions/88/Vacuum+Analyze+Database+

If you don't need most of the hands in your database for your current game i would recommend to create a new database and import only the hands you need in this database. You should find them in the archive folder (default c:\hmarchive).