PS: Out of memory when trying to import HH

[thegreatmodi]

Im out of memory when trying to import HH while playing on PS. I dont have any databases up, I just have the import Auto import HH window open, and when I looked at memory usage while operation was performing it was only using 1.5gigs out of 3gigs available.

[ptrack pat]

You need to use the Utilities > File Splitter window to split the large hand history file into smaller files and import from those files instead of the one large one.

[thegreatmodi]

Even when im using auto import function? Its only trying to import 10 hands or less every 60s?

[ptrack pat]

Where did you get these hand history files from? I've never seen this kind of error with just importing hand histories that PokerStars writes to the hard drive as you play. The only time I've seen it is when you got some hand history files from somewhere else and the files contain 1000's of hands per file.

[thegreatmodi]

from poker stars its always worked until today i have 100s of thousands of hands, when i hit auto timer it tries to import hands and its says insufficient memory something come up about smart heap library then says error access viotalation Ox12D9632 and says it has to close. any other problem ive had with PT i can usually just surf forums until i find the fix

[ptrack pat]

Restart the computer.
Open PT and the auto-import window. Click the Enable Logging box. Hit Force Import.
If you still get this error, open PT again, go back to the auto-import window and click the View Log link.
Copy/paste the text of the log file into a reply.

[thegreatmodi]

Logging started: 06/16/2009 09:12:19 PM
PS HH Folder: C:\Program Files\PokerStars\HandHistory
Main Settings: Database: MTT (PostgreSQL) MV=on FLDR=C:\Users\Adam\Documents\My Received Files\PokerTracker Database\Pokertars AR=off TMR=1
==============================
58 new or updated file(s) found since last import.
Processing file: C:\Program Files\PokerStars\HandHistory\TheGreatModi\HH20090616 T171772534 No Limit Hold'em $2 + $0.20.txt - last hand read/imported from this file = 0
Processing file: C:\Program Files\PokerStars\HandHistory\TheGreatModi\HH20090616 T171772534 No Limit Hold'em $2 + $0.20.txt - processing starting at line 0

[ptrack pat]

Have you been importing tournament summaries for all of these tournaments you are playing and have you played in a lot of large tournaments where you are importing summaries for 1000's of player names?

The only thing I can think of is you have a database with a huge number of player names and when it caches all that data, it's running out of memory.

Try using the Utilities > PostgreSQL Database Functions window to do a FULL vacuum/analyze on the database.

[thegreatmodi]

yeah i have about 500k players in my database, and have been loading tournament summaries. What are my options I would rather have the HHs instead of the summaries.

[thegreatmodi]

FULL vacuum/analyze, I do that quite often. Tried again still no memory.