Purge Feature
Results 1 to 2 of 2

Thread: Purge Feature

  1. #1
    Join Date
    Nov 2008

    Default Purge Feature

    Feature Request.

    If i have a player with 100k hands, i would like to keep the most recent 10k hands, and purge the oldest 90k

    Repeat for all players with 10k+ hands.

    This would be an efficient way to reduce database size, without losing invididual players (which is what happens when you delete hands before a certain date)

  2. #2
    *** HM3! *** fozzy71's Avatar
    Join Date
    Sep 1971
    HM Support


    This is not technically possible for a variety of reasons. You will have to use existing purge features/filters to purge older hands as needed and you can try setting the HM3 - HUD - HUD Options - Filters - 'Stats from the last XXXXX hands' filter to '10000' if that is the most data you want to see in a HUD on a player.

    Note: HM3 does not yet have a way to vaccum the database after a purge, to reclaim some of that space, built in to HM3. This feature request has been documented in detail and provided to the developers for future consideration.
    HMT-4431: Add database vacuum option to tools

    If you want to be notified if/when it is added please send an email via the 'Contact Support' link and include "Notify Me When HMT-4431 Is Resolved" in the subject line and body of the email.

    You can vacuum a database manually:

    - Install the SQLite Browser - https://sqlitebrowser.org/dl/
    - Restart your computer and leave HM3 and the HM3 Server (HUD Only Mode) closed.
    - Launch the SQLite Browser program and then click 'Open Database' option, switch the File Type box to 'All Files' and select your database you want to compact.
    - Now click Tools - 'Compact Database...' - 'OK'.
    - The process will likely say 'not responding' but just be patient as it can take a good bit of time for larger databases.
    - When the process finishes the 'Compact Database' window that had popped up will close and then you can close the main DB Browser software.

    Here is a short video example of me showing the process on an old test database - https://www.dropbox.com/s/rxknx2tld0...owser.mp4?dl=0

Similar Threads

  1. Feature Request: Opening/Closing Feature
    By Mt.Splashmore in forum TableNinja
    Replies: 2
    Last Post: 02-15-2013, 08:34 PM
  2. Replies: 10
    Last Post: 08-26-2012, 07:58 PM
  3. Purge hands feature related questions
    By tobe4funas in forum General Support
    Replies: 1
    Last Post: 02-19-2012, 05:43 PM
  4. Is the Purge Hands feature supposed to take so LONG?
    By domino66 in forum Manager General
    Replies: 2
    Last Post: 08-14-2008, 11:33 AM

Posting Permissions

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