PDA

View Full Version : uploading many hands and...



Kakitee
12-28-2010, 07:25 PM
import seems to be stuck on part X/109 parts of large file and there are 12 large files. HEM isn't not responding however..

should i close and restart the upload (perhaps 1 large file at a time instead of all 12)?

or leave it and expect results? (it has been stuck on part X for 2hrs or so now.

any other ideas welcome obviously

- files are the hh docs requested from stars fwiw

cheers

Patvs
12-28-2010, 07:37 PM
What's the size in MB of the largest .txt file you're importing?

Which SQL version are you using, how much RAM does your computer have, and did you ever edit the postgresql.conf file (assigning more RAM to SQL)?

It's likely your computer will get "stuck" during the import of such a large .txt file when it runs out of memory. (the memory assigned to SQL)

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

(update SQL, edit postgresql.conf--> reboot, and try to reimport the file again)

Kakitee
12-28-2010, 07:47 PM
thanks for tips, sounds like a chore tho, i'll just wait till i get a new pc and hope it doesn't brick again