slow import, virtualbox on ubuntu
Page 1 of 2 12 LastLast
Results 1 to 10 of 13
  1. #1
    Junior Member
    Join Date
    Aug 2008
    Posts
    10

    Default slow import, virtualbox on ubuntu

    Hi,

    I'm using HM on Virtualbox @ ubuntu 8.04 with a postgres database (8.2) running on the Ubuntu Host. My system is an Intel Dual Core 3 GHz (8400) with 4 GB DDR2-800 RAM. Nevertheless I only get 20 hands/s which is quite slow.

    My questions are the following:
    Are 20 hands/s normal for this system and does anyone know how to accelerate the import?

    Best regards, Frank

    edit: oh, and of course I'm doing a vaccum/analyse every two days...
    Last edited by freanki; 09-18-2008 at 12:32 PM. Reason: adding vaccum/ana

  2. #2
    Tech Support Manager morny's Avatar
    Join Date
    Jul 2008
    Location
    Ireland
    Posts
    20,888

    Default

    It actually varies quite a bit and some people with better specs get less than people with less. Vacuum's will help in running faster queries but defragmenting has a better effect for people with slow import speeds, some people have got noticeable increases doing that.

    So go to Start > Program Files > Accessories > System Tools > Disk Defrag

    Also the bigger your database the more youll notice a decrease in import speeds although it shouldnt effect query runnings etc so much

    The other point is that youll notice it increasing slowly and evening off so over smaller samples it might be a bit slower but should improve over bigger imports. Also makesure you have http://www.holdemmanager.com/downloa...te1.06.03h.exe
    --------------------------------------------------------------------------------------------------------------------
    We welcome any feedback on any solutions we provide, this helps us to provide better quality solutions in the future.

  3. #3
    Junior Member
    Join Date
    Aug 2008
    Posts
    10

    Default

    As I wrote, I'm using linux (in my case ext3) for the database so I guess defragmenting the windows partition shouldn't get any improvements.

    I'm also using the newest version of HM. My database consists of over 5 mio. hands and the last import (today) of 500.000 hands took over 8 hours ( so a bit less then 20 hands/sec).

    But I have to say that this doesn't effect stats at the tables. I'm fully happy with that, it's just the import thing...

  4. #4
    Administrator Rvg72's Avatar
    Join Date
    Jul 2008
    Posts
    3,056

    Default

    Can you tell us a bit about the makeup of hands you are importing? ie, avg file size, which sites, which game types etc

    I might see something that could be adjusted based on that but it is likely that you will be at 20 until I'm able to make some more refinements to this system.

    Roy

  5. #5
    Junior Member
    Join Date
    Aug 2008
    Posts
    10

    Default

    sure, the filesize is between 1 kb and 140 kb. The average size is 82 kb and the pokersite is pokerstars. Gametype is NL holdem.

  6. #6
    Tech Support Manager morny's Avatar
    Join Date
    Jul 2008
    Location
    Ireland
    Posts
    20,888

    Default

    Do you play FR,6Max or HU?
    --------------------------------------------------------------------------------------------------------------------
    We welcome any feedback on any solutions we provide, this helps us to provide better quality solutions in the future.

  7. #7
    Junior Member
    Join Date
    Aug 2008
    Posts
    10

    Default

    I'm playing FR only.

  8. #8
    Junior Member
    Join Date
    Aug 2008
    Posts
    10

    Default

    Are those information enough?

  9. #9
    Administrator Rvg72's Avatar
    Join Date
    Jul 2008
    Posts
    3,056

    Default

    Full Ring is about half the speed of 6 max since there is much more data being saved. The file sizes are really small too - if you can merged them into bigger files of apx 1MB (or even a couple hundred KB or more) then that should make a pretty big difference.

    Roy

  10. #10
    HM2 Shark Tank Member
    Join Date
    Jul 2008
    Posts
    676

    Default

    why HM doesn't import new HH that are being played at the moment simultaneously along x HH that are being stored at the auto import folder?

    i.e
    i have 100k that havnt been imported yet.
    i open poker room and start playing, fire auto import.
    HM is starting to import all of those 100k , while new hands wont be imported during live (online lol) session

    thanks in advance,

Similar Threads

  1. SLOW and impossible
    By rotvis in forum Manager General
    Replies: 8
    Last Post: 08-27-2008, 06:09 AM
  2. Hands import too slow
    By aftajvila in forum Manager General
    Replies: 1
    Last Post: 08-12-2008, 07:46 PM
  3. EXTREMELY slow first import
    By ClutchCity in forum Manager General
    Replies: 32
    Last Post: 08-04-2008, 02:05 PM
  4. slow
    By Suerte in forum Manager General
    Replies: 1
    Last Post: 08-02-2008, 09:19 PM
  5. Very slow importing
    By Russell99 in forum Manager General
    Replies: 8
    Last Post: 07-14-2008, 02:22 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
  •