HEM taking very long to display hands for the session

[fish888]

Hi there,

I'm using beta 40. ive recently purged a lot of my hands so i dont think my database is very clunky. However, HEM is taking up to two or three minutes to display the hands played per session (under Cash Games > Sessions). This is despite the fact that i've already selected "Last 100", if u know what i mean... And I've very recently maintained my database, ie vacuumed and reindexed it using pgAdmin.

[fozzy71]

I would suggest you do the majority of the things in this thread: http://www.holdemmanager.net/forum/showthread.php?t=11194

Some of the most important things, imo:

- Remove the WinnerName, WinnerCards and WinnerWon from the Hands View Column Selector
- Turning off logging and deleting existing logs
- Vacuum/Full/Analyze, then Reindex - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=163
- 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

[LT22]

was having same problem, removing the Winner info from the Hands column fixed it