Delete old hands, database works faster ?
Results 1 to 7 of 7
  1. #1
    Member
    Join Date
    Oct 2008
    Posts
    77

    Default Delete old hands, database works faster ?

    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 ?

  2. #2
    HM Support netsrak's Avatar
    Join Date
    Feb 2009
    Location
    Germany
    Posts
    25,795

    Default

    FAQ - Hold'em Manager Poker Tracking Software :: Purge Hands

    and check the performance tips from the link in my signature

  3. #3
    Member
    Join Date
    Oct 2008
    Posts
    77

    Default

    Thanks a lot.

  4. #4
    Senior Member
    Join Date
    Feb 2010
    Posts
    125

    Default

    I'm in settings but I see no "purge hands" on the left hand side

  5. #5
    You're out! udbrky's Avatar
    Join Date
    Jul 2008
    Posts
    20,898
    Regards udbrky (Chris)

  6. #6
    Senior Member
    Join Date
    Feb 2010
    Posts
    125

    Default

    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.

  7. #7
    You're out! udbrky's Avatar
    Join Date
    Jul 2008
    Posts
    20,898

    Default

    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)

    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

    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?
    Regards udbrky (Chris)

Similar Threads

  1. PostgreSQL: Cannot delete old database
    By PoK3rJacK in forum Manager General
    Replies: 3
    Last Post: 06-02-2009, 02:00 PM
  2. How to delete some of my database and keep the stats ?
    By radotdr in forum Manager General
    Replies: 1
    Last Post: 02-06-2009, 03:48 PM
  3. Delete Database?
    By bandy in forum Manager General
    Replies: 1
    Last Post: 01-26-2009, 02:22 PM
  4. Delete database
    By transbetacism in forum Manager General
    Replies: 1
    Last Post: 12-14-2008, 03:43 PM
  5. How to delete a database?
    By euroglot in forum Manager General
    Replies: 1
    Last Post: 08-09-2008, 06:37 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •