performance issues

[justdoit]

i have tried several tweaks as written in the forums but still suffer tremendous performance problems (lags, freezes,...)
can someone of the team please have a look at my system via skype?

[karstenkloss]

What's your hardware-setup?

[justdoit]

CPU Type OctalCore AMD FX-8120, 3400 MHz (17 x 200)
Motherboard Name ASRock 970 Extreme3 (2 PCI, 2 PCI-E x1, 2 PCI-E x16, 4 DDR3 DIMM, Audio, Gigabit LAN)
2x DIMM1: G Skill F3-12800CL9-4GBXL 4 GB DDR3-1600 DDR3 SDRAM (11-11-11-28 @ 800 MHz) (10-10-10-27 @ 761 MHz) (9-9-9-24 @ 685 MHz) (8-8-8-22 @ 609 MHz) (7-7-7-19 @ 533 MHz) (6-6-6-16 @ 457 MHz)
Video Adapter NVIDIA GeForce GTX 560 Ti (1048256 KB)
2x Monitor Dell 3008WFP (Digital) [30" LCD] (G501H01F284L)
Disk Drive SAMSUNG SSD 830 Series ATA Device (SATA-III)

should be sufficient?

[karstenkloss]

Pretty much the same as i have. Only differences: i have a weaker CPU and 2x Samsung 830 series (one for Win 7 and programs one for the database).

What Antivirus you use? For me the change to Windows Security Essentials was a big improvement.

I use Postgresql 9.0 (optimized configuration) and don't have any performance issues with a 5kk Hands database + NoteCaddy with 150 definitions.

Also: did you remove the Cap in the HM2-config-file? Helped me also a Little bit.

[justdoit]

thanks for getting back
i use f-secure
how did you remove the cap?
and i still use postgres 8.4 because of hm1... ist postgres 9 the recommendation for hm2?

[Patvs]

Which Operating System, Firewall, and Anti-Virus are you using?

How large is your database?

PostgreSQL 9.0 and 9.2 have a special 64 bit build, so if you have a 64 bit operating system and more than 4 GB RAM, it could (theoretically) improve performance.

[justdoit]

i use windows 7 64bit with f-secure antivirus, no firewall
the database is around 60gb

can i install postgresql9 and continue using a hm1 database created with postgres 8? i still would like to be able to use hm1 with the database until hm2 runs smooth...

[udbrky]

1) Please close HM

2) Please open PGAdminIII

It is in the Start -> Postgres folder.

3) Enter your postgres password. The default password is typically postgrespass.

4) Open the databases.

5) Highlight your database.

6) Right click, click maintenance.

7) Run the vacuum and analyze and reindex functions.

http://faq.holdemmanager.com/questions/88/Vacuum+Analyze+Database+

Please try again.

1) Please make sure you are installing on an administrator account and running as an administrator.

2) Please turn off UAC.

3) You'll need to add:
- hmupdate.exe (only exists during update)
- holdemmanager.exe
- hudfuncapps.exe
- postgres and pg_ctl, your poker client .exe
- table ninja.exe
- notecaddy.business.dll and notecaddy.contents.dll from the modules folder in holdemmanager's program files folder (you might have to type in the names in some firewalls, they do not show)

to the exceptions list in your firewall and antivirus. ****

4) Make sure that windows is fully updated. Keep checking for updates until it says twice five minutes apart that there are no more updates available.

5) You need to make sure that this folder*, as well as c:\programfiles\holdemmanager2, c:\hm2archive, c:\hmarchive and your site's hand history folder are each not read only** and that all permissions are set to full for your user name. ***

8/7/Vista: C:\Users\username\AppData\Roaming\HoldemManager\

XP: C:\Documents and Settings\User_name\Application Data\HoldemManager


* You will need to show hidden files. See this tutorial for showing system and hidden files:

http://hm2faq.holdemmanager.com/questions/832/How+are+Hidden+Files+Viewed+in+Windows%3F+

See the location here for win 7:

http://www.udbrky.com/hmsupport/configfile.PNG

See the location here for win xp:

http://www.udbrky.com/hmsupport/configfile.PNG

** You will need to right click the folder, open properties. At the bottom in Attributes, uncheck the Read-Only. The folder will continue showing read only after that, this is an issue in Windows

*** This is in Properties as well, in Security.

****Please see this guide for Windows Firewall:

http://hm2faq.holdemmanager.com/questions/1052/Windows+Firewall+%7B47%7D+Defender+Problems

[udbrky]

You can run multiple postgres versions. They will be on different ports. Your first one is port 5432 by default. Your second one will be port 5433.

In HM1, you can control the port in the database control panel tool.

In HM2, it is in the database control panel. When you create the database, you can choose the postgres information.