HEM taking very long to display hands for the session
Results 1 to 3 of 3
  1. #1
    Member
    Join Date
    Jul 2009
    Posts
    39

    Default HEM taking very long to display hands for the session

    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.

  2. #2
    *** HM3! *** fozzy71's Avatar
    Join Date
    Jun 2005
    Location
    HM Support
    Posts
    32,775

    Default

    I would suggest you do the majority of the things in this thread: http://www.holdemmanager.net/forum/s...ad.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/afm...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

  3. #3
    Member
    Join Date
    Aug 2008
    Posts
    69

    Default

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

Similar Threads

  1. Database Restore Taking a Long Time
    By MHagan22 in forum Manager General
    Replies: 2
    Last Post: 02-21-2011, 07:51 AM
  2. No one interested in taking notes on hands?
    By Lunatic973 in forum Manager General
    Replies: 4
    Last Post: 10-10-2009, 07:51 AM
  3. HEM taking years to import hands.
    By green_29 in forum Manager General
    Replies: 1
    Last Post: 08-18-2009, 03:49 PM
  4. Display all stats no just current session
    By Skinny_Buddha in forum Manager General
    Replies: 2
    Last Post: 05-19-2009, 03:25 AM
  5. Replies: 1
    Last Post: 04-25-2009, 04:52 PM

Posting Permissions

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