PDA

View Full Version : How to make HEM faster?



dynamite140
02-05-2010, 04:54 PM
I read the TOP 10 HEM performance tips

http://forums.holdemmanager.com/showthread.php?t=11194

However, can someone please explain and list the steps for vacuuming

This is what I see for vacuuming 8.1


http://faq.holdemmanager.com/?faqid=163

I do not understand where are the steps here.


http://www.linuxinsight.com/optimize_postgresql_database_size.html

Also, i do understand this. Are these directions or just statements?


I have HEM since July and could not do any of these steps b/c these don't even sound like directions to me! I mean i click on it and i see the definition of vacuuming but does not give me the steps to do it.

Thanks

dynamite140
02-05-2010, 11:11 PM
fozzy are u there?

_Loki_
02-05-2010, 11:57 PM
** "Vacuum Analyze Database: Doing this frees up disk space and allows your database to run faster"
http://faq.holdemmanager.com/questions/88/Vacuum+Analyze+Database+

** "Holdem Manager Runs Slow"
(I think most/all of the info in this link is in the performance tips you already looked at):
http://faq.holdemmanager.com/questions/109/Holdem+Manager+Runs+Slow

** "Advanced PostgreSQL Tuning: Is there anything I can do to speed up my PostgreSQL? Advanced PC Users only. We came across the following post on 2+2 about how to speed up PostgreSQL."
http://faq.holdemmanager.com/questions/89/Advanced+PostgreSQL+Tuning

In addition to the above I strongly recommend this website if your OS is Windows:
http://www.blackviper.com/
On the site go to the page for your Windows version & read carefully - there's a lot of advice on altering how your Windows Services run
Do only the changes in the 'safe' column at first
I advise you to write down what services you change in case you need to turn one of them on again at a later date

dynamite140
02-06-2010, 03:09 AM
what is the password?

dynamite140
02-06-2010, 03:28 AM
okay i got the password

Where is the power option? I use XP and i do not see the HIGH PERFORMANCE option

_Loki_
02-06-2010, 04:04 AM
Hi Dynamite

If you are not having problems with the HUD lagging etc then just stick to the vacuum process & also you need to defrag now & then

****************
What I do is

** Vacuum - full

then reboot

** Defrag
Download one of these & defrag using the 'defrag & optimise' setting
http://www.iobit.com/iobitsmartdefrag.html
http://www.auslogics.com/en/software/disk-defrag/
I found Auslogics was better at optimising my XP Pro than Smart Defrag

then reboot again

To be honest I don't know if all those reboots are necessary, but I do it anyway !!

There is also a reindex option in postgreSQL, but I'm not sure when to use this so I actually reindex after vacuuming - I have a lot to learn

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

If you are still having problems then come back & post here, but don't try anything you are not sure about

If you are more adventurous then before you try anything new do backups of things you can't replace easily - especially your Hands archive - keep a copy of them away from your computer- storing them on the internet is good - that's free too !!

dynamite140
02-06-2010, 04:24 AM
my hud lags all the time when i 24 table. I think it starts lagging once i do 16 tables. My computer is a pentium 4 computer though 2.8Ghz. It has 2GB RAM and runs XP.

Yes i use the same defragger as you auslogics. So far it still is slow at the moment.

_Loki_
02-06-2010, 04:46 AM
Are you updated to 1.10.02 ?

What have you done from the performance tips ?

#############################

These are some of the things that Fozzy suggests...

Make sure you disable multiple hud panels if you are using them, and change all HUD opacities to maximum, and if you are using a transparent HUD background panel, change it to a solid color like black.

Make sure your video card drivers and windows auto updates are fully updated

For XP Pro: Make sure you have Microsoft .NET Framework 3.0 SP2 installed.

And these for general HM performance.

- Remove the WinnerName, WinnerCards and WinnerWon from the Hands View Column Selector
- Turning off logging and deleting existing logs
- Vacuum/Full/Analyze, then Reindex
- 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

dynamite140
02-06-2010, 02:11 PM
Can you explain the multiple panels part? I saw that step but did not know how to do it.


You say


Make sure you disable multiple hud panels if you are using them, and change all HUD opacities to maximum, and if you are using a transparent HUD background panel, change it to a solid color like black.



I do not know how to do this

_Loki_
02-06-2010, 02:31 PM
Hi Dynamite - You may not have multiple panels in your HUD anyway

This is how to set up multiple panels:
http://www.holdemmanager.net/FAQ/afmviewfaq.aspx?topicid=30&faqid=134
If you have multiple panels just reverse the steps in the FAQ

Have you downloaded this?
http://www.holdemmanager.com/downloads/HoldemManagerManual.pdf
It explains most of the HM & postgreSQL features including...

Vacuum/reindex
multiple panels
HUD background colours
opacity... etc etc

dynamite140
02-06-2010, 03:12 PM
i do not have multiple panels checked.

By the way, today my HUD keeps on turning on and off. Do you know why this is so? I think it must have been the vacuuming and all that i did yesterday? Every hand or 2 hands my HUD turns off and then turn back on.

fozzy71
02-06-2010, 10:06 PM
Hi Dynamite

If you are not having problems with the HUD lagging etc then just stick to the vacuum process & also you need to defrag now & then

****************
What I do is

** Vacuum - full

then reboot

** Defrag

Make sure you stop the postgresql service before you defrag or your DB won't be defragmented.



There is also a reindex option in postgreSQL, but I'm not sure when to use this so I actually reindex after vacuuming - I have a lot to learn

The Reindex should NOT be done every time you vacuum. I only suggest doing it after any large bulk imports, purges, etc. It can/should also be used if you think your DB has become damaged/corrupt.

http://www.postgresql.org/docs/8.1/interactive/sql-reindex.html


Description

REINDEX rebuilds an index using the data stored in the index's table, replacing the old copy of the index. There are two main reasons to use REINDEX:

An index has become corrupted, and no longer contains valid data. Although in theory this should never happen, in practice indexes may become corrupted due to software bugs or hardware failures. REINDEX provides a recovery method.

The index in question contains a lot of dead index pages that are not being reclaimed. This can occur with B-tree indexes in PostgreSQL under certain access patterns. REINDEX provides a way to reduce the space consumption of the index by writing a new version of the index without the dead pages. See Section 22.2 for more information.




my hud lags all the time when i 24 table. I think it starts lagging once i do 16 tables. My computer is a pentium 4 computer though 2.8Ghz. It has 2GB RAM and runs XP.


How old is the PC? 2 - 3 years old? It sounds similar to my PC that I just replaced.

What other programs are you running at the same time? What site? Do you use AHK or other Hotkeys programs? Music and web browser? Try turning off any transparency in your HUD Options > Player Preferences and all Opacity settings should be set to Max.

What processes are in your System Tray? Can you post a screenshot of your Task Manager > Processes sorted by Descending CPU and RAM usage?

Right-click bottom Task-Bar > Task Manager

To attach it to a thread in the forums, look below the post reply button when you start a new thread and you'll see a manage attachments button. Click this and attach the file.



i do not have multiple panels checked.

By the way, today my HUD keeps on turning on and off. Do you know why this is so? I think it must have been the vacuuming and all that i did yesterday? Every hand or 2 hands my HUD turns off and then turn back on.

Try a new DB as a test. Did you change any settings in the HUD Options > Tables Preferences recently? Try toggling the [x] Force On Top option. Are your video card drivers and Windows fully updated?

The Minder
02-06-2010, 11:27 PM
my hud lags all the time when i 24 table. I think it starts lagging once i do 16 tables. My computer is a pentium 4 computer though 2.8Ghz. It has 2GB RAM and runs XP.

Yes i use the same defragger as you auslogics. So far it still is slow at the moment.

Bingo! Nothing you can do by way of defrag the HD or vacuum the db is going to mount to a hill of beans. You're pushing your system to it's limit. Btw, the main prob is that you're prolly running a 5600rpm HD with minimal cache. I'm surprised it hasn't screamed at you and quit.

dynamite140
02-07-2010, 12:06 AM
Actually its a 7200 RPM. Someone checked it out on me when i told them what my hard drive is. The computer is 4 years old. It actually had only 512MB of Ram and i upgraded it to 2GB ram about 3 months ago. Its faster than it was before but still lags

Yes i do use web browser and play music. I do not use hotkeys or any of those other things that is related.


How do i stop the PostSQL fozzy?


Someone below you mention its my pentium 4. Is that the most likely reason?

The Minder
02-07-2010, 06:06 AM
Actually its a 7200 RPM. Someone checked it out on me when i told them what my hard drive is. The computer is 4 years old. It actually had only 512MB of Ram and i upgraded it to 2GB ram about 3 months ago. Its faster than it was before but still lags

Yes i do use web browser and play music. I do not use hotkeys or any of those other things that is related.


How do i stop the PostSQL fozzy?


Someone below you mention its my pentium 4. Is that the most likely reason?
It is almost impossible to narrow it down to a single hardware issue, although the HD may still be an issue if it only has a small cache. The P4 is not the most powerful pup in the litter, but it's not bad. You're more likely to have issues with the motherboard and/or video subsystems than you will with a lack of CPU grunt.

I'd recommend kicking the RAM up to max (which should be 4Gb) and don't forget to match the RAM speed to your FSB speed.

There are also some good optimizers available that will tune XP for max performance. Try HiJackThis to clean out browser and startup sequence followed by a thing called Tune Up Utilities (http://www.tune-up.com/products/tuneup-utilities/) that will clean out a lot of other crap that Windows systems build up. This last one isn't free, but you get 30 days use (last time I checked) before it stops working.

dynamite140
02-07-2010, 05:03 PM
MY Ram is max 2GB which is why i cannot do 4GB.