PDA

View Full Version : Problem Importing Hands



thanksb
01-04-2011, 02:10 AM
I asked stars to send me my hands for the year (about 1.7 million) but when I load them I can only get about 1 million.

Please help!

netsrak
01-04-2011, 06:59 AM
Please update to 1.11.05e: http://www.holdemmanager.com/Downloads/HmUpdate.exe

Does it work if you import the hands into a new database?
Does the import show any errors?

thanksb
01-04-2011, 06:31 PM
it just says duplicate hands

Patvs
01-04-2011, 09:05 PM
Which SQL version are you using, how much RAM do you have...
did Stars sent you all your hands in 1 file... how large is that .txt file?

Read:
http://forums.holdemmanager.com/manager-general/11194-top-10-hem-performance-increase-tips.html


And assign more RAM to PostgreSQL.
And turn off logging.

What you also can do... import the file... but stop import every 30 minutes / 200.000 hands. VACUUM/ANALYSE the database.
Then import the file again--> repeat