View Full Version : How to speed up HEM
malkasgambit
06-26-2009, 10:03 AM
Hi,
You guys have been extremely helpful thus far, my apologies for taking up your time with retarded questions. Hopefully my last one:
My HEM is extremely slow, and I only have hands from June 13th (about 100k). I'm on a pretty beastly machine so hopefully that's not the issue. Core 2 Duo, 2GB ram, Vista (ew). Just ... when I try to retrieve hands or "view all" hands from an entire session it takes about 20-30 seconds to load. Besides running the vaccuum database from the PGAdmin III management thingy, what are some other things I can do to speed up HEM?
malkasgambit
06-26-2009, 10:07 AM
Ah yes also, how do I change the time and date for me on HEM to reflect my current time/date?
fozzy71
06-26-2009, 10:51 AM
Hi,
You guys have been extremely helpful thus far, my apologies for taking up your time with retarded questions. Hopefully my last one:
My HEM is extremely slow, and I only have hands from June 13th (about 100k). I'm on a pretty beastly machine so hopefully that's not the issue. Core 2 Duo, 2GB ram, Vista (ew). Just ... when I try to retrieve hands or "view all" hands from an entire session it takes about 20-30 seconds to load. Besides running the vaccuum database from the PGAdmin III management thingy, what are some other things I can do to speed up HEM?
I just posted this last night for a customer having slow import speeds, but these steps should help all aspects of HM's performance. This is my process I do at least once a month.
- 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.
- 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 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 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
*****************************
Ah yes also, how do I change the time and date for me on HEM to reflect my current time/date?
You need to play around with the 'My Day Starts At option' to try and make it 'think' it is in your time-zome. - http://www.holdemmanager.net/faq/?f=65
Powered by vBulletin® Version 4.2.3 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.