View Full Version : replayer
niamor
04-24-2010, 07:01 AM
Since the last update, the replayer is really slow, especially when i want to see all hand of a session, so what can i do to fix it ?
Sometimes an error message appears :
http://img43.imageshack.us/img43/6084/bugec.png (http://img43.imageshack.us/i/bugec.png/)
Uploaded with ImageShack.us (http://imageshack.us)
fozzy71
04-24-2010, 12:48 PM
Do you perform regular DB maintenance?
I would suggest you do the majority of the things in this thread: Top 10: HEM performance increase tips - Holdem Manager Forums (http://www.holdemmanager.net/forum/showthread.php?t=11194)
Some of the most important things, imo:
- Remove the WinnerName, WinnerCards and WinnerWon from the Options > Hands View Column Selector..
- Turning off logging and deleting existing logs
1 - Close HM and Open PGAdmin
2 - connect to postgresql server and then to the DB. Password is postgrespass in case you ever need it.
3 - Right-Click > Maintenance on the DB.
4 - Vacuum, Analyze > OK
Wait for it to finish and change the greyed out OK button to a Done button.
Do that ever 10 -30k hands.
Every 50 - 100k hands, after finishing the steps above:
A - Right-Click > Maintenance on the DB.
B - Reindex > OK
Wait for it to finish and change the greyed out OK button to a Done button.
Next we need to Stop the PostgreSQL service so the Defragmenter can Defrag the Database.
Start > Programs > PostgreSQL 8,4 > Stop Server
Open Smart Defrag > Select both drive letter checkboxes > Analyze
Pick suggested Defrag process > Start Defrag
After Smart Defrag finishes you should restart your computer.
If you need to use HM before you restart your PC, then you need to Start Server.
Start > Programs > PostgreSQL 8,4 > Start Server
Powered by vBulletin® Version 4.2.3 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.