PDA

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