PDA

View Full Version : Cannot optimize database



steve_cordy@live.com
01-29-2011, 09:58 AM
My databse is quite large at around 4 mil hands and I think that is causing it to run slowly when running reports.

I have tried to optimze via databse management using the tips in FAQ but get the following error message;

HoldemManagerDatabaseMaintenance.MainScreen.optimi zeAsync()[24/01/2011 21:30] Error...please contact support@holdemmanager.com
Can you help fix this?

If not can you suggest alternative ways to improve performance?

PS- I have a fast PC and latest HEM version etc

Patvs
01-29-2011, 09:06 PM
Read:
http://forums.holdemmanager.com/manager-general/11194-top-10-hem-performance-increase-tips.html



And vacuum/analyse/reindex the database in pgadminIII instead