PDA

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