Exporting /Memory Problem
Results 1 to 6 of 6
  1. #1
    Junior Member
    Join Date
    Jan 2009
    Posts
    14

    Default Exporting /Memory Problem

    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

  2. #2
    HM Support Patvs's Avatar
    Join Date
    Feb 2009
    Location
    Amsterdam, the Netherlands
    Posts
    33,523

    Default

    read: http://forums.holdemmanager.com/mana...ease-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)
    Participate in the Beta release of the newest Hold'em Manager version: HM Cloud. Sign-up HERE.

    If you would like to leave some feedback to help us improve the quality of the solutions, and/or the support quality you received, - you can do this here

  3. #3
    Junior Member
    Join Date
    Jan 2009
    Posts
    14

    Default

    (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

  4. #4
    HM Support Patvs's Avatar
    Join Date
    Feb 2009
    Location
    Amsterdam, the Netherlands
    Posts
    33,523

    Default

    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
    Participate in the Beta release of the newest Hold'em Manager version: HM Cloud. Sign-up HERE.

    If you would like to leave some feedback to help us improve the quality of the solutions, and/or the support quality you received, - you can do this here

  5. #5
    Junior Member
    Join Date
    Jan 2009
    Posts
    14

    Default

    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

  6. #6
    HM Support Patvs's Avatar
    Join Date
    Feb 2009
    Location
    Amsterdam, the Netherlands
    Posts
    33,523

    Default

    Archive folder should just be:
    C:/HMArchive

    (you don't have to go into the program files folder)
    Participate in the Beta release of the newest Hold'em Manager version: HM Cloud. Sign-up HERE.

    If you would like to leave some feedback to help us improve the quality of the solutions, and/or the support quality you received, - you can do this here

Similar Threads

  1. Problem with exporting
    By TheRYC in forum Manager General
    Replies: 1
    Last Post: 02-13-2010, 01:31 PM
  2. Problem Exporting HUD
    By max00d in forum Manager General
    Replies: 4
    Last Post: 01-22-2010, 11:46 AM
  3. postgres problem: vacuum analyse/memory exceded at
    By horsetranquilizer in forum Manager General
    Replies: 2
    Last Post: 11-23-2009, 10:08 PM
  4. Problem exporting hands
    By un1bomber in forum Manager General
    Replies: 3
    Last Post: 11-07-2009, 06:54 PM
  5. Problem exporting just my own hands
    By bw07507 in forum Manager General
    Replies: 1
    Last Post: 09-02-2009, 02:00 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •