PDA

View Full Version : optimizing players crashing



cooplat
06-17-2011, 02:30 PM
Hi,

I have a huge database and most of the time when an optimising player starts i get this message after an hour or so :

"the following error occured: a timeout has occured. If you were establishing a connection increase Timeout value in ConnectionString. If you were executing a command, increate the CommandTimeout value in ConnectionString or in your NpgsqCommand object"

Most of the time, i have to run the optimising player 10 times before it works (meaning more than 10hours) , what should I do ?

cooplat
06-17-2011, 02:46 PM
I've found relative posts, so i'll try to purge some hands and do a vacum

Patvs
06-17-2011, 06:39 PM
Updating PostgreSQL, turning off logging, adding port 5432/postgres.exe to the firewall exceptions list, and assigning more RAM to PostgreSQL (by editing the postgresql.conf file) may also help.


Read:
http://forums.holdemmanager.com/manager-general/11194-top-10-hem-performance-increase-tips.html



And creating a new database and just reimporting all your hands again.