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).
Powered by vBulletin® Version 4.2.3 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.