purged database

[DrDunne]

Hi. I purged my database of all non-hero hands from before the start of this year because I cannot use HM2 in game as it is too slow despite it running on an SSD. But it is still running too slow for me to take notes in-game: the note box takes about 4 seconds to open after I click the note icon in the HUD, and even then I cannot type properly. Meanwhile I am timing out on my tables while HM2 is being so sluggish.

My ...\PostgreSQL\8.4\data\base folder size is 27.2GB after the purge, and my ...\Roaming\HoldemManager\Database folder size is 1.19GB.

What is causing the problem? I will probably re-import all of those hands because the purge did absolutely nothing.

I can provide information about my PC specifications in case it is caused by that.

Thanks...

[udbrky]

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?

If you continue to have problems, please duplicate the issue and send us log files with a detailed description of what you were doing and what problems you were experiencing:
- Open Windows Event Viewer's (Control Panel > System & Security > Administrative Tools or Start > Search > 'Event Viewer') > Windows Logs > Applications.
- Check for any errors and send the information (Save All Events As...).
- Please send your \HM2Logs folder files as well - Hold'Em Manager 2 FAQs - Poker Software :: How Do I Send a Log File to Holdem Manager Support?

When sending any files please zip them (right-click > send to > compressed folder) before attaching them to an email. If the attachment is larger than 10MB please upload them to a file hosting site like dropbox, then right-click > 'copy public link' and paste the download link directly into the support ticket email. If you have any problems with dropbox try using filedropper.com