PDA

View Full Version : Hands section won't load



built2tilt
02-13-2010, 03:47 PM
Hey,

When I go to the hands section in my holdem manager I get this:

http://i149.photobucket.com/albums/s42/joewhu1/hmproblem.jpg

I have a lot of hands on the database.

fozzy71
02-13-2010, 06:45 PM
Please update to the latest beta - http://www.holdemmanager.net/hmbetaupdate

What are your machine specs?

I would suggest you do the majority of the things in this thread: Top 10: HEM performance increase tips - Holdem Manager Forums (http://www.holdemmanager.net/forum/showthread.php?t=11194)

Some of the most important things, imo:

- Remove the WinnerName, WinnerCards and WinnerWon from the Options > Hands View Column Selecto
- Turning off logging and deleting existing logs
- Vacuum/Full/Analyze, then Reindex - FAQ - Hold'em Manager Poker Tracking Software :: Vacuum Analyze Database (http://faq.holdemmanager.com/questions/88/Vacuum+Analyze+Database+#manual)
- Defrag last and make sure you stop the postgresql service before you defrag. I personally use Smart Defrag.
- Do a Cold Boot (Shut Down > Start) before you use HM again


If you still get the same error, try making a new DB.

*Try creating a new UTF DB - FAQ - Hold'em Manager Poker Tracking Software :: Create / Delete Database (http://faq.holdemmanager.com/questions/75/Create+%7B47%7D+Delete+Database)
*Now import a small portion of your \HMArchive so you can see if the problem exists in the new DB - FAQ - Hold'em Manager Poker Tracking Software :: How to Import & Export Hands (http://faq.holdemmanager.com/questions/98/How+to+Import+%26+Export+Hands)
*If the new DB seems to work properly, you will want to import the rest of your archives to the new DB, export/import the hands from the old DB to the new DB, and export/import any player notes and tourney summaries - and then delete the old DB.
*Make sure you export/backup everything before deleting the old DB