Super Slow Import Speeds
Results 1 to 6 of 6
  1. #1
    Senior Member
    Join Date
    Feb 2009
    Posts
    297

    Default Super Slow Import Speeds

    I just purchased this HDD since my database crashed:
    http://forums.holdemmanager.com/mana...ease-tips.html

    Is this just horrible or something? I cannot get things to import fast what so ever. Each file I am importing is 10 megs in size - and I have about 25 gigs worth. The max speeds I get is like 30-50 hands/sec.

    I have/use
    *Bought new HDD (Cant afford solid state as that would be way too expensive for the size I need) (Use a Cord 2 Quad 2.66 GHZ CPU)
    *Installed 8 gigs of ram
    *Set all priorities to high in task maager
    *Newest hem/postgres
    *Defrag (yet even on newest imports its going slow.. like 30-50hands/sec on a brand new empty drive with only POSTGRES and HEM installed)
    *Re-index (again..even though I have JUST started importing)
    *Did tons of the WIN 7 performance tips
    *Turned off indexing/Set everything for best performance

    Still cannot get good speeds. Is that HDD just not good? What else am I missing? Is it because they are 10 meg files and should be smaller? I am trying to import in 2 gig chunks (in 10 meg files) and not getting anywhere fast!

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

    Default

    30-50 hands/s already is really fast considering they are 10 MB .txt files.
    If the files would be a LOT smaller (<200 kb) you should see faster import speeds.
    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
    Senior Member
    Join Date
    Feb 2009
    Posts
    297

    Default

    Do you know of any good notepad programs to break files down small?

    I have found a few but they all dont know where one hand ends and another begins so if I break them down too small (from the 1 gig ish files that I had extracted) there is tons and tons of import errors since hands are randomly cut off....
    Last edited by 4entourage; 07-25-2010 at 01:34 PM.

  4. #4
    Senior Member
    Join Date
    Feb 2009
    Posts
    297

    Default

    Nvm Im good I found one but still importing super slow....
    Last edited by 4entourage; 07-25-2010 at 08:38 PM.

  5. #5
    Senior Member
    Join Date
    Feb 2009
    Posts
    297

    Default

    Soooo my database crashed - you guys couldnt find out why. Now I am getting horrible import speeds - not getting any help.

    I was just finishing a 500 meg chunk of 200kb import files--went from about 40hands/sec down to about 20---so once it was done I did a re-index and a defrag. I now went on to the next import and it was again 500megs of 200kb files --- and is going at 8.7 hands/sec -- SLOWER after the re-index and defrag. Something is going on - I need a team viewer or something because this is not working how it has for last 2 years...
    Last edited by 4entourage; 07-25-2010 at 10:28 PM.

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

    Default

    pm sent
    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. Replies: 7
    Last Post: 04-24-2010, 01:08 AM
  2. I purge hands now DB is super slow
    By thepurenuts in forum Manager General
    Replies: 2
    Last Post: 02-27-2010, 11:16 PM
  3. Very slow import speeds (New Computer)
    By PatInTheHat in forum Manager General
    Replies: 7
    Last Post: 12-21-2009, 02:33 PM
  4. Import Super Slow when observing tables
    By preya001 in forum Manager General
    Replies: 2
    Last Post: 08-29-2009, 02:16 PM
  5. Super slow database
    By anytwocantyou in forum Manager General
    Replies: 5
    Last Post: 07-24-2009, 10:37 AM

Posting Permissions

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