PDA

View Full Version : over 100k tournaments in 1 database



Lance
01-26-2012, 10:46 PM
Since i have reached 100k tournaments in a database i am not able to show a graph for all tournaments. If i try it, HEM shows me an empty chart and after a while HEM crashes with a message "out of memory".
Do you have any experience with this ? Is it possible to do something without need of making a new database ?

Patvs
01-27-2012, 02:30 AM
Read:
http://forums.holdemmanager.com/manager-general/11194-top-10-hem-performance-increase-tips.html,

Try:
-1 editing the postgresql.config file and reboot
-2 updating PostgreSQL to 8.4.10
-3 reindexing the database in pgadminIII
-4 setting exceptions to postgres.exe, holdemmanager.exe to the Windows Firewall

-5 if that doesn't resolve it create a NEW database and reimport the hands.