PDA

View Full Version : Exporting /Memory Problem



chelsea7
11-18-2010, 05:30 PM
Hi

I'm trying to filter all hands from this year ready to export them. I set the filter to this year and when I click the "All" button it thinks about it and then I get the error message...

Unhandled exception has occurred in your system. Exception of type "System.OutOfMemoryException" was thrown.

I have never purged the database and have about 290k hands in there.

Your advices appreciated

Thanks

Patvs
11-19-2010, 01:44 AM
read: http://forums.holdemmanager.com/manager-general/11194-top-10-hem-performance-increase-tips.html



Edit your postgresql.conf file assigning more memory to SQL and REBOOT.
Also vacuum/analyse your database in pgadminIII before you export the hands.


(it's easier to just run a import from file / import from folder on ALL the 2010 files from your archive folder... instead of exporting 290K hands which can take up lots of system resources: RAM and harddisk activity)

chelsea7
11-19-2010, 01:52 AM
(it's easier to just run a import from file / import from folder on ALL the 2010 files from your archive folder... [/QUOTE]

Where can I find the archive folder?

Thanks

Patvs
11-19-2010, 02:24 AM
Default is: C:/HMArchive

All hands should be sorted by DATE. And even filed in folders, for year, month and day, so you can easily run a "import from folder" to import a specific month/year

chelsea7
11-22-2010, 05:41 AM
Hi

Having trouble finding the folder. In my C drive I have:-

C - Program Files - RVG Software - Holdem Manager.

The sub folders in Holdem Manager are:-

- Assemblies
- Config
- Filters
- Fishfinder
- Images
- Importing
- Logs
- ReplayerSkin
- Reports
- Temp

Am I looking in the right place??

Many Thanks

Patvs
11-22-2010, 09:12 PM
Archive folder should just be:
C:/HMArchive

(you don't have to go into the program files folder)