Very slow import

[olegkulik]

Hey there. Import goes very slow like 20 hands/s was about 120 hands/sec after reinstalling my XP to windows 7 32bit home basic and changing harddrive to 1TB. Any Ideas why?

[fozzy71]

http://forums.holdemmanager.com/manager-general/21793-tips-importing-large-databases.html?highlight=import+speed


http://forums.holdemmanager.com/manager-general/26916-hand-import-speed.html

http://forums.holdemmanager.com/manager-general/21793-tips-importing-large-databases.html?highlight=import+speed

http://forums.holdemmanager.com/manager-general/6783-import-speed-how-increase-speed.html

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 Selecto
- Turning off logging and deleting existing logs
- Vacuum/Full/Analyze, then Reindex - FAQ - Hold'em Manager Poker Tracking Software :: Vacuum Analyze Database (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