PDA

View Full Version : HEM Lags like mad after update



IK828
06-28-2009, 08:29 PM
Hi, After I updated my HEM it lags like mad when I play on FTP and Stars to a point where I cant really play more then like 10 tables... Everything would freeze and I cant click/do anything then all of a sudden everything unfreezes and works fine for the next couple of minutes. I already tried tons of things liek defragging my cpu and vacuuming my DB etc and its no help. I also switched to a different version of tablemanager which actually drastically reduced the freezing/lag, but does not completely remove it. I was wondering if there is anyway to fix this?

I did a lot of searching up in the forums for people w/ similar problems and i've turned off live trackign and still no luck...

any help would be greatly appreciated.. this is really frustrating me!

fozzy71
06-29-2009, 07:50 AM
What specific version of HM are you running, and what Operating system? Have you added exceptions to the Firewall? (explained in link below) If you are using Multiple Panels in the HUD, you can try turning them off. When defragging it is important to stop the PostgreSQL service, so it can defrag your SQL files properly. (also explained in included link)


The current version of HM is 1.09 Beta 9 - http://www.holdemmanager.com/downloads/HmBetaUpdate.exe


Here are some things you can do to improve overall PostgreSQL performance.


- I would start by turning off the logging in your SQL and deleting all the logs that are wasting space:

*If you want some help with this part let me know*



- Start > My Computer > Tools > Folder Options > View > UnCheck 'Hide Extensions for known file types' > OK

- C:\Program Files\PostgreSQL\data\postgresql.conf > Right-Click > Open With.. > NotePad > Check 'Always use this program'

- Scroll about half way down to ~Lines 245 - 260:

- The last line of this block of code, for the 'logging_collector', must be changed from Off to On.


------------------------------------------------------------------------------
# ERROR REPORTING AND LOGGING
#------------------------------------------------------------------------------

# - Where to Log -

log_destination = 'stderr' # Valid values are combinations of
# stderr, csvlog, syslog and eventlog,
# depending on platform. csvlog
# requires logging_collector to be on.

# This is used when logging to stderr:
logging_collector = off # Enable capturing of stderr and csvlog

File > Save; File > Close

Start > Programs > PostgreSQL 8.3 > Reload Configuration.

*edit:
- Start > My Computer > C:\Program Files\PostgreSQL\data\pg_log, or C:\Program Files (x86)\PostgreSQL\data\pg_log, if you have 64 bit Vista. Delete all files in that folder. And it might be a good idea to empty your recycle bin at that point, or use a 3rd party utility like CCleaner (http://www.ccleaner.com) to clean up all your junk/temporary files. You want to do this before you get to the vacuum and defrag process.


************************************************** *****************


- Vacuum:

http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=60


- If you get an error, then vacuum manually:

http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=163


************************************************** *****************


- You can follow this FAQ for other ways to make HEM run faster. One of the most important steps is the defrag. I personally use Defraggler (http://www.defraggler.com/) on my PC. Make sure you Stop the PostgreSQL service before you defrag, and Start it back up after, so it will defrag properly.

http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=162


************************************************** *****************



- You can also use the SQL Tuning Wizard :

http://www.holdemmanager.net/faq/afmmain.aspx?faqid=172


*****************************