View Full Version : Import performance speed
SootedNinjas
12-11-2008, 03:09 AM
I just bought and installed for the first time HEM 1.07 starting with an empty DB.
When the import started the 1st batch of hands of about 500k the Hands/s was around 140 but by the time the batch was complete it was down to 70 hands/s. It was slowly decreasing as the import progresses.
Now I am on my second batch of another 500k hands and it is processing 40 hands / second.
What's up with this ?
Anybody, anyone ?
Escalated to morny (Support), he will answere asap.
SootedNinjas
12-11-2008, 03:22 PM
Now is down to 35 hands/s
morny
12-11-2008, 05:02 PM
As the database increases the import speed will get slower but the actual speed of displaying hands shouldnt be effected much. There can also be a big diffference between type of hands i.e HU vs FR and even some sites like Party have a much slower import rate. I wouldnt pay too much attention to the start rate however as its like downloading it takes a while to average out however it is a bit unusual that it dropped from 70 to 35 so i would recommend doing a defrag of your hard drive especially if you havent done one lately.
Roy has said hes going to look into rewriting this to improve things again but since its such a big job it will be a couple of months before he can get it finished.
TierTier
12-12-2008, 09:30 AM
SN,
I'm in a similar boat as you and am down to 11-13 h/s when I grab the hands from yesterday in the morning.
SootedNinjas
12-12-2008, 01:44 PM
After a defrag as suggested I imported the next 500k hands and the rate was at 45 hands/s for these batch.
After that batch the rate went down but it has been holding steady for the last 1.5M hands @ 35 hands/s.
Powered by vBulletin® Version 4.2.3 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.