importing taking FOREVER
Results 1 to 2 of 2
  1. #1
    Senior Member
    Join Date
    Mar 2009
    Posts
    173

    Default importing taking FOREVER

    Hi

    My PC has been importing 5 million hands from a a folder for the past 40 hours.

    At first the import rate was over 120 hands per sec, but that rate gradually slow down, atm at 30 hands per sec after 4 million hands.

    Is that because the bigger the Database the slower it gets?

    I havent been able to play all the time cos HEM is busy importing.

    I have a decent PC, i.e. Quad Core 2, 2.66Ghz with 8Gb RAM.

    Will HEM's performance be affected by the size of the DB?

    Regards

  2. #2
    *** HM3! *** fozzy71's Avatar
    Join Date
    Sep 1971
    Location
    HM Support
    Posts
    30,594

    Default

    This is standard procedure with huge imports. The DB will get progressively slower bulk import speeds as it grows, but this should not affect normal play (only the bulk imports). I suggest you break up large imports like yours, into smaller groups so the PC isn't busy for such a long time. Then import a portion each night while sleeping so you can use the PC during the day.

    Proper DB maintenance and performance can help to reduce the speed degradation.

    I would have also suggested you turn off the SQL logging before importing so many files.

    The DB maintenance and logging is explained here:

    I would suggest you do the majority of the things in this thread: http://www.holdemmanager.net/forum/s...ad.php?t=11194

    Some of the most important things, imo:

    - Remove the WinnerName, WinnerCards and WinnerWon from the Hands View Column Selector
    - Turning off logging and deleting existing logs
    - Vacuum/Full/Analyze, then Reindex - http://www.holdemmanager.net/faq/afm...aspx?faqid=163
    - Defrag last and make sure you stop the postgresql service before you defrag. I personally use Defraggler.
    - Do a Cold Boot (Shut Down > Start) before you use HM again

Similar Threads

  1. HEM takes forever to load my last 100 hands
    By ata in forum Manager General
    Replies: 7
    Last Post: 01-06-2009, 12:53 AM
  2. [1.06.03h] optimization - takes forever?
    By virge in forum Manager General
    Replies: 3
    Last Post: 09-18-2008, 10:51 PM
  3. Mucked Holecards Take Forever To Appear
    By guitarizt in forum Manager General
    Replies: 8
    Last Post: 08-11-2008, 11:55 PM
  4. Note taking
    By Leonardo51 in forum Manager General
    Replies: 1
    Last Post: 08-10-2008, 06:48 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
  •