purge

[maartens]

Hi HM

Can I purge hands that were imported today? They are from many dates, but I want to delete the ones Manual Imported today.

Thanks

[udbrky]

You can select them in reports. Highlight them at the bottom, right-click and delete.

[fozzy71]

There is also a Tools - 'Purge Hands...' feature that might be easier if deleting a lot of hands.

Note: Purging or Deleting hands doesn't currently reclaim used space yet as it doesn't yet have vacuum tools automated or built into HM3*.


HMT-3929
Purge Hands does not reduce database hmdb file size


This issue has been documented in detail and provided to the developers to resolve. If you want to be notified when it is fixed please send an email via the 'Contact Support' link (https://support.holdemmanager.com/) and include "Notify Me When HMT-3929 Is Resolved" in the subject line and body of the email.

*It is possible to vacuum the database manually with a separate program called SQLite Browser.

- 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'.
- Now you can close the SQLIte Browser.


Here is a short video example (https://www.dropbox.com/s/rxknx2tld0fh77e/Vacuum%20HM3%20SQLite%20Dabtase%20with%20Browser.m p4?dl=0) of me showing the process on an old test database.

[maartens]

Hi thanks.... do either of those methods filter or sort by Date Imported?

[fozzy71]

Hi thanks.... do either of those methods filter or sort by Date Imported?

No, there is no way to filter by date imported. You can only filter/purge by date the hands were played. The only other thing I can suggest is you create a new database and only import the files you want in the database, then delete the old database you imported too many/wrong hands to.