PDA

View Full Version : Delete old hands, database works faster ?



Leif
03-03-2010, 07:00 AM
I have ton of imported hands, but only use hands in my hud that are newer that 3 months old.

Now, if i have 4 month of hands, say: 1 jan - 30 april, how can i delete the hands from 1. jan - 30 jan ?.

If i do the following:

1) show stats between 1. jan-31.jan (for my player name).
2) click on "All Hands" instead of "Last 100"
3) Click on "delete all hands"

it only deletes my hands, when most of the hands i am not involved, because they are datamined.

How do i delete all entries for a period 1. jan - 30. jan ?

And, will this speed up, as compared to have a ever growing database ?

netsrak
03-03-2010, 08:24 AM
FAQ - Hold'em Manager Poker Tracking Software :: Purge Hands (http://faq.holdemmanager.com/questions/197/Purge+Hands)

and check the performance tips from the link in my signature

Leif
03-04-2010, 05:36 AM
Thanks a lot.

phaze3131
09-15-2017, 04:22 PM
I'm in settings but I see no "purge hands" on the left hand side

udbrky
09-15-2017, 09:11 PM
162277

phaze3131
09-16-2017, 11:57 AM
ah ok I see the problem, this is HM1 support, I have HM2.

This came up first in google for the query.

For others who come here, go to Database not Settings, and there you will see the Purge option.

udbrky
09-16-2017, 10:55 PM
Yes, post in HM2 for help, not HM1. It is in the Database manager.

Then:

Please try to vacuum/analyze and reindex your database - Hold'Em Manager 2 FAQs - Poker Software :: Database Manager (Ribbon) (http://hm2faq.holdemmanager.com/questions/5/Database+Manager+%28Ribbon%29#maintenance)

If you continue to have problems, try the following:

Try creating a new DataBase and import a small portion of your \HM2Archive so you can see if the problem exists in the new DB - Hold'Em Manager 2 FAQs - Poker Software :: How to create a new database and import previously played hands (http://hm2faq.holdemmanager.com/questions/3091/How+to+create+a+new+database+and+import+previously +played+hands)

If the new database seems to work properly, it sounds like your database might be corrupt. Please continue to use the new database and import the rest of your hands using the steps above. This is why regular backups are a good idea. If your database becomes corrupt you can restore a backup and only have to import the most recent hands (that were played after the backup was created) and edit any tournament results if necessary. I recommend keeping at least the most recent 2 or 3 backups in case the most recent one does not restore properly you can try the previous backup.

Here is a FAQ explaining how to backup your database and all settings in one easy step - Hold'Em Manager 2 FAQs - Poker Software :: How does Backup and Restore Database, Settings and HUD configs work? (http://hm2faq.holdemmanager.com/questions/1471/How+does+Backup+and+Restore+Database%2C+Settings+a nd+HUD+configs+work%3F)