PDA

View Full Version : Why are hands importing at 7/s?



kremlin72
03-01-2011, 12:16 PM
Hi. I've recently created a new database because my old one was corrupt, I'm currently importing the 680,000 hands from my Archive HEM folder and its going incredibly slowly, the first 10,000 went at 7 per second, the estimated time remaining is nearly 20 hours. Is there anything I can do to speed the process up? Thanks.

fozzy71
03-01-2011, 04:20 PM
There is nothing you can do to speed up a large import that is already in process. It is best to just wait it out. Your machine performance and hand history file size and quantity affect that.

In general:

I would suggest you do the majority of the things in this thread: 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 Selection.
- Turning off logging and deleting existing logs
- Vacuum/Full/Analyze, then Reindex - http://faq.holdemmanager.com/questions/88/Vacuum+Analyze+Database+#manual
- Defrag last and make sure you stop the postgresql service before you defrag. I personally use Smart Defrag.
- Do a Cold Boot (Shut Down > Start) before you use HM again